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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Number of days past due
One way,
=IF(F3=0,"",IF(F3<TODAY(),"PM Due "&TODAY()-F3&" days","")) Regards, Alan. "rrupp" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Number of days past due
=IF(F3<TODAY(),"overdue by " & TODAY()-F3 & " days","")
Gord Dibben MS Excel MVP On Wed, 18 Mar 2009 09:16:22 -0700, rrupp wrote: 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. |
Reply |
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 |