Results 1 to 3 of 3
  1. #1

    Datevalue (2000)

    I want to add and subtract dates in a colum.
    =DATEVALUE("10/5/2001") works, but doesn't seem to take a reference like:

    What can I do to get datevalue to use a date in another cell?
    My ultimate goal i something like:
    EDATE(DATEVALUE("C1"),5) which won't work because datevalue won't work.

  2. #2
    Silver Lounger
    Join Date
    Mar 2001
    Springfield, Ohio, USA
    Thanked 1 Time in 1 Post

    Re: Datevalue (2000)

    Glen, you are making it too difficult. You probably will never need to use the DATEVALUE function.

    If you have 10/5/2001 in cell C1, then if you enter =EDATE(C1,5) in cell C2, you will see the result as 37320. Now if you format this cell as a date (the easiest way is with the format-painter button), then you will see the desired result, 3/5/2002. HTH --Sam
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  3. #3

    Re: Datevalue (2000)

    Thanks for simplifying it.
    I'm doing penance for trying to follow the example in the help file:

Posting Permissions

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