# Number of days past due

Discussion in 'Microsoft Excel Worksheet Functions' started by rrupp, Mar 18, 2009.

1. ### rruppGuest

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.

rrupp, Mar 18, 2009

2. ### AlanGuest

One way,
=IF(F3=0,"",IF(F3<TODAY(),"PM Due "&TODAY()-F3&" days",""))
Regards,
Alan.
"rrupp" <> wrote in message
news...
>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, Mar 18, 2009

3. ### Gord DibbenGuest

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

Gord Dibben, Mar 18, 2009