# Number of days past due

rrupp
Guest
Posts: n/a

 18th Mar 2009
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
Guest
Posts: n/a

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

Gord Dibben
Guest
Posts: n/a

 18th Mar 2009
=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.

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post Chuck M Microsoft Outlook Discussion 0 1st Feb 2008 03:40 PM =?Utf-8?B?SmVzc2ljYQ==?= Microsoft Access VBA Modules 11 7th Jul 2005 09:54 PM =?Utf-8?B?bWVsYXJtb3I=?= Microsoft Excel Worksheet Functions 3 2nd Jun 2005 06:13 AM =?Utf-8?B?Y29va2llMDQ=?= Microsoft Excel Programming 1 14th Jan 2005 11:04 PM =?Utf-8?B?RnVua2VlaWl6?= Microsoft Excel Misc 1 5th Oct 2004 05:09 PM

Features