+ Reply to Thread
Results 1 to 5 of 5

Referencing another cell in a Date Value Formula

  1. #1
    Registered User
    Join Date
    06-20-2013
    Location
    Brisbane, Australia
    MS-Off Ver
    Excel 2010
    Posts
    2

    Referencing another cell in a Date Value Formula

    Hi,

    I am trying to create a date value formula to refence the date in another cell, minus todays date, to give a 'days to go' value.

    Currently I have only been sucessful using the following formula:

    =DATEVALUE("28/06/2013")-TODAY()


    I would like to remove the 28/06/2013 from the formula and have it reference the date from another cell.

    For example, if I change the formula to:

    =DATEVALUE("A7")-TODAY()

    This brings up an error. I have the date in cell A7 as 28/06/2013 and formatted to date, but this date may need to be changed, and I want to avoid having to update the cell A7, and the DATEVALUE formula in the next cell.

    Thanks

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: Referencing another cell in a Date Value Formula

    Try it like this:

    =A7-TODAY()

    and format the cell with the formula in as Number with 0dp or as General.

    Hope this helps.

    Pete

  3. #3
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Referencing another cell in a Date Value Formula

    Just use the cell reference by itself:

    =A7-TODAY()
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  4. #4
    Registered User
    Join Date
    06-20-2013
    Location
    Brisbane, Australia
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Referencing another cell in a Date Value Formula

    That did the trick.

    Thanks guys!!

  5. #5
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Referencing another cell in a Date Value Formula

    You're welcome. We appreciate the feedback!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1