| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Caluclating days past due
Frankly, I didn't fully understand your request - however, you may try:
=TODAY()-D5 while using the "1904 Date System' ['Tolls' 'Options' 'Calculation' tab] Micky "Chris" wrote: I am trying to calculate days past due. For and invoice tracker. I have C5=date invoiced/D5= Payment due/ h5=days pat due. I need a formula to calculate total days outstanding. I thought =(D5-C5)-Today() but this is not working. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rolling date looking 30 Days past | Excel Worksheet Functions | |||
| Number of days past due | Excel Worksheet Functions | |||
| Count No of days past due | Excel Worksheet Functions | |||
| how to make formula to get past due 30-60-90 days | Excel Worksheet Functions | |||
| flag date within a cell after 15 days have past? | Excel Worksheet Functions | |||
Linear Mode
