Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Nov 2002
    Location
    London, Gtr London, England
    Posts
    496
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Using NOW or TODAY with DATEDIF

    Dear loungers,

    If I use this formula:

    =-(DATEDIF(TODAY(), GoLiveStartDate,"D")+3)/7

    I get an endless row of hashes. The same with NOW() instead of TODAY().
    The formula works with a cell reference.

    What is happening, and can I fix it?

    liz

  2. #2
    4 Star Lounger
    Join Date
    Nov 2002
    Location
    London, Gtr London, England
    Posts
    496
    Thanks
    8
    Thanked 0 Times in 0 Posts
    OK found it, the format wasn't set to a number for the cell

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Glad you solved it.
    Just to clarify the problem: the hashes come since Excel does not understand negative dates or times so any negative number will display like that with a date or time format.

    Steve

Tags for this Thread

Posting Permissions

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