Results 1 to 8 of 8
  1. #1
    2 Star Lounger
    Join Date
    May 2011
    Posts
    193
    Thanks
    11
    Thanked 3 Times in 3 Posts

    Displaying date across a workbook in EXCEL

    I have an Excel workbook that has 11 separate pages. The 1st page of the workbook has it's date changed daily and the other pages reference the 1st page's date to get their date line. This works fine on 9 of the remaining 10 pages; however, one page the '=reference!' command doesn't work correctly - it returns a date of ' Saturday January 1, 1900'.

    Obviously some setting on this page is incorrect. But which one?

  2. #2
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,975
    Thanks
    156
    Thanked 768 Times in 700 Posts
    mmi16,

    For some reason your formula resulted in a value of 1 which is converted as a date to Saturday January 1,1900.

  3. #3
    2 Star Lounger
    Join Date
    May 2011
    Posts
    193
    Thanks
    11
    Thanked 3 Times in 3 Posts
    Quote Originally Posted by Maudibe View Post
    mmi16,

    For some reason your formula resulted in a value of 1 which is converted as a date to Saturday January 1,1900.
    The actual 'formula' being used is a direct copy of the same formula that is being used on all the other pages - the other pages display correctly, this one page does not.

  4. #4
    WS Lounge VIP
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    9,004
    Thanks
    63
    Thanked 1,116 Times in 1,039 Posts
    And the formula is?

    cheers, Paul

  5. #5
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    3,407
    Thanks
    164
    Thanked 638 Times in 606 Posts
    Hi

    ..have you tried 'copying' the formula again (from a sheet where it is working) and 'pasting' the formula to the sheet where it isn't working???

    zeddy

  6. #6
    2 Star Lounger
    Join Date
    May 2011
    Posts
    193
    Thanks
    11
    Thanked 3 Times in 3 Posts
    Copy & Paste is my friend. Always has been.

  7. #7
    2 Star Lounger
    Join Date
    May 2011
    Posts
    193
    Thanks
    11
    Thanked 3 Times in 3 Posts
    Got it working properly - don't know what I changed.

  8. #8
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    3,407
    Thanks
    164
    Thanked 638 Times in 606 Posts
    Hi mmi16

    A change is as good as arrest.

    ..thanks for posting back to let us know you have the issue fixed.

    zeddy

Posting Permissions

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