Number of days past due

[rrupp]

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.

 

[Alan]

One way,
=IF(F3=0,"",IF(F3<TODAY(),"PM Due "&TODAY()-F3&" days",""))
Regards,
Alan.

 

[Gord Dibben]

=IF(F3<TODAY(),"overdue by " & TODAY()-F3 & " days","")


Gord Dibben MS Excel MVP