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. joel claes

    Converting sequence of days into number of days

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

    Past Due - Due Dates

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

    A number of days into weeks and days

    Guest, Aug 30, 2005, in forum: Microsoft Excel Worksheet Functions
    Replies:
    4
    Views:
    537
    Guest
    Aug 31, 2005
  4. 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:
    684
    Roger Govier
    Feb 18, 2008
  5. Mrs H

    Count No of days past due

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

Share This Page