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
    Messages:
    2
    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. 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:
    201
    MrShorty
    Dec 15, 2005
  2. Guest

    Help Need Formula for Calculator

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

    Mortgage calculator: finish date?

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

    Dual income calculator help

    ASasser, Jul 2, 2008, in forum: Microsoft Excel Worksheet Functions
    Replies:
    5
    Views:
    304
    Pete_UK
    Jul 2, 2008
  5. Titanium

    I need a Line of Credit Calculator

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

Share This Page