H Harlan Grove Oct 1, 2003 #2 Is there a formula in Excel for Days Sales Outstanding? Click to expand... No, but if you provide details on how your data is organized, others could provide specific approaches for how to do this in your data layout. In general, these would look like =SUMIF(PaymentDueDates,"<"&(TODAY()-90),BalanceDueAmounts)
Is there a formula in Excel for Days Sales Outstanding? Click to expand... No, but if you provide details on how your data is organized, others could provide specific approaches for how to do this in your data layout. In general, these would look like =SUMIF(PaymentDueDates,"<"&(TODAY()-90),BalanceDueAmounts)