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.

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.

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.