Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Jun 2004
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Cell Format (Excel 2000)

    HELP! I am trying to calculate the number of days between steps in the attached excel spreadsheet, however, for some reason, excel is not recognizing my dates. For example, I am trying to calculate how many days are between C2 and P2, so I type the formula =P2-C2. Then I get an error message (#VALUE). Can anyone help me figure this out?

    Thanks!!!

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Cell Format (Excel 2000)

    The dates are not in stored in Excel as dates but are instead text. You can use the macro by <!profile=JohnBF>JohnBF<!/profile> in <post#=332113>post 332113</post#> to convert the text values to dates.

  3. #3
    New Lounger
    Join Date
    Jun 2004
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cell Format (Excel 2000)

    Tony,

    THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU!!!!!!!!!!! <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23>

  4. #4
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Cell Format (Excel 2000)

    Glad to help, but most of those thank you's should be for John, my part in finding the solution was remembering that he had written the macro.

Posting Permissions

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