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.

One way,
=IF(F3=0,"",IF(F3<TODAY(),"PM Due "&TODAY()-F3&" days",""))
Regards,
Alan.
"rrupp" <(E-Mail Removed)> wrote in message
news0F5B4B9-FE4F-4971-A038-(E-Mail Removed)...
>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.

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


Gord Dibben MS Excel MVP

On Wed, 18 Mar 2009 09:16:22 -0700, rrupp <(E-Mail Removed)>
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.