| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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, |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Calculate age from DOB in years, months days | Excel Worksheet Functions | |||
| calculate days | Excel Discussion (Misc queries) | |||
| Calculate days | Excel Discussion (Misc queries) | |||
| Calculate the Days | Excel Worksheet Functions | |||
| Why does excel calculate difference in days from February - March | Excel Worksheet Functions | |||
Linear Mode
