PC Review


Reply
Thread Tools Rate Thread

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.
 
Reply With Quote
 
 
 
 
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.


 
Reply With Quote
 
 
 
 
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.


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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 Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Outlook 2007 Tasks showing Due In instead of past due Chuck M Microsoft Outlook Discussion 0 1st Feb 2008 03:40 PM
Field change color when a date is about to be due or is past due =?Utf-8?B?SmVzc2ljYQ==?= Microsoft Access VBA Modules 11 7th Jul 2005 09:54 PM
Past Due - Due Dates =?Utf-8?B?bWVsYXJtb3I=?= Microsoft Excel Worksheet Functions 3 2nd Jun 2005 06:13 AM
HIGHLIGHT A DATE 10 DAYS BEFORE IT IS PAST DUE =?Utf-8?B?Y29va2llMDQ=?= Microsoft Excel Programming 1 14th Jan 2005 11:04 PM
How do I automatically calculate days past due? =?Utf-8?B?RnVua2VlaWl6?= Microsoft Excel Misc 1 5th Oct 2004 05:09 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:03 PM.