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

P

past due

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,
 
J

Jim Thomlinson

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMPRODUCT where between 2 dates 3
Timebase help!!! 1
Aging Report Problem 0
Setting up 30, 60, and 90 days delinquency 8
Conditional Format where ANY date is >= 30, 60, 90 days EXCEL 2007 1
Calculate 60 days from Start Date - including weekends 5
calculating payment terms "End of Month +30". 1
Calculate Percentage of Total for Category 6

Top