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.
|