Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Number of days past due
I have set up a formula, in Excel 2003, for days past due. So the formula is
calculated based on numbers from columns and then I figured out part of what I want to do but not all of it. Example: =IF(F3<TODAY(),"PM Due","") Right now it either says PM Due or it's blank. I would like to display not only that it's past due, but how many days it's past due. Can anyone assist me with this formula? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count No of days past due | Excel Worksheet Functions | |||
how to make formula to get past due 30-60-90 days | Excel Worksheet Functions | |||
Calculating how many days past in a month from today | Excel Discussion (Misc queries) | |||
how do i convert a number of days to years, months & days? | Excel Discussion (Misc queries) | |||
flag date within a cell after 15 days have past? | Excel Worksheet Functions |