I need Help with a date calculator

Discussion in 'Microsoft Excel Worksheet Functions' started by paggota78, Jul 30, 2012.

  1. paggota78

    paggota78

    Joined:
    Jul 30, 2012
    Likes Received:
    0
    I need to be able to determine a future date from today's date by adding the # of days.

    For example. I need to now what the date would be from today if I add 120 days.

    Thank you for your help. I need this to track the freshness of beer in my warehouse.

    I think this string can be edited to work.

    ="Days until 12/31/"&YEAR(NOW())
     
    Last edited: Jul 30, 2012
    paggota78, Jul 30, 2012
    #1
    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. Otto

    Using a cell like a calculator with the running total appearing in that

    Otto, Aug 26, 2003, in forum: Microsoft Excel Worksheet Functions
    Replies:
    1
    Views:
    243
    Harald Staff
    Aug 26, 2003
  2. Guest

    TAN different to a calculator? Please help would be appreciated lo

    Guest, Dec 15, 2005, in forum: Microsoft Excel Worksheet Functions
    Replies:
    5
    Views:
    247
    MrShorty
    Dec 15, 2005
  3. Guest

    Need help to find a date (latest date) from a column

    Guest, Mar 20, 2006, in forum: Microsoft Excel Worksheet Functions
    Replies:
    4
    Views:
    240
  4. Guest

    Help Need Formula for Calculator

    Guest, Jun 7, 2006, in forum: Microsoft Excel Worksheet Functions
    Replies:
    4
    Views:
    154
    David Biddulph
    Jun 7, 2006
  5. Guest

    Mortgage calculator: finish date?

    Guest, Aug 17, 2006, in forum: Microsoft Excel Worksheet Functions
    Replies:
    2
    Views:
    193
    Guest
    Aug 17, 2006
  6. ASasser

    Dual income calculator help

    ASasser, Jul 2, 2008, in forum: Microsoft Excel Worksheet Functions
    Replies:
    5
    Views:
    325
    Pete_UK
    Jul 2, 2008
  7. Randy

    Help w/ simple calculator formula

    Randy, Aug 12, 2008, in forum: Microsoft Excel Worksheet Functions
    Replies:
    5
    Views:
    148
    Bob Bridges
    Aug 13, 2008
  8. Titanium

    I need a Line of Credit Calculator

    Titanium, Sep 2, 2008, in forum: Microsoft Excel Worksheet Functions
    Replies:
    5
    Views:
    196
    LauriNan
    Oct 27, 2008
Loading...