Number of days past due

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

  1. rrupp

    rrupp Guest

    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
    #1
    1. Advertisements

  2. rrupp

    Alan Guest

    One way,
    =IF(F3=0,"",IF(F3<TODAY(),"PM Due "&TODAY()-F3&" days",""))
    Regards,
    Alan.
    "rrupp" <> wrote in message
    news:D...
    >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
    #2
    1. Advertisements

  3. rrupp

    Gord Dibben Guest

    =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
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Guest

    Highlight Past Due Dates

    Guest, Dec 1, 2003, in forum: Microsoft Excel Worksheet Functions
    Replies:
    2
    Views:
    228
  2. joel claes

    Converting sequence of days into number of days

    joel claes, Apr 23, 2004, in forum: Microsoft Excel Worksheet Functions
    Replies:
    1
    Views:
    260
    Daniel.M
    Apr 23, 2004
  3. Guest

    Past Due - Due Dates

    Guest, Jun 2, 2005, in forum: Microsoft Excel Worksheet Functions
    Replies:
    3
    Views:
    404
    Peo Sjoblom
    Jun 2, 2005
  4. Guest

    A number of days into weeks and days

    Guest, Aug 30, 2005, in forum: Microsoft Excel Worksheet Functions
    Replies:
    4
    Views:
    646
    Guest
    Aug 31, 2005
  5. Guest

    need to show when date is past due

    Guest, Sep 28, 2005, in forum: Microsoft Excel Worksheet Functions
    Replies:
    5
    Views:
    333
    Myrna Larson
    Sep 28, 2005
  6. ASHRAF

    how to make formula to get past due 30-60-90 days

    ASHRAF, Feb 18, 2008, in forum: Microsoft Excel Worksheet Functions
    Replies:
    2
    Views:
    850
    Roger Govier
    Feb 18, 2008
  7. Mrs H

    Count No of days past due

    Mrs H, Feb 5, 2009, in forum: Microsoft Excel Worksheet Functions
    Replies:
    4
    Views:
    421
    Michael.Tarnowski
    Feb 6, 2009
  8. nannybears

    Past due function

    nannybears, Jun 9, 2009, in forum: Microsoft Excel Worksheet Functions
    Replies:
    5
    Views:
    286
    nannybears
    Jun 10, 2009
Loading...