How do I calculate 30, 60, 90,120 days delinquency in Excel
 

I'm trying to calculate past due amounts.

Date Total payment balance 30 days 60 days 90 120
1/29/05 100 25 75

Please help,

How do I calculate 30, 60, 90,120 days delinquency in Excel
 

Here are your formulas for 30 60 90 and 120 days past due. This assumes that
your payment terms are net 30, and that the format you showed starts in cell
A1.

=IF(AND(TODAY()-A2=30, TODAY()-A2,60), D2, "")
=IF(AND(TODAY()-A2=60, TODAY()-A2,90), D2, "")
=IF(AND(TODAY()-A2=90, TODAY()-A2,120), D2, "")
=IF(TODAY()-A2=120, D2, "")

HTH

"past due" wrote:

I'm trying to calculate past due amounts.

Date Total payment balance 30 days 60 days 90 120
1/29/05 100 25 75

Please help,