Results 1 to 8 of 8
  1. #1
    2 Star Lounger
    Join Date
    May 2011
    Posts
    157
    Thanks
    10
    Thanked 2 Times in 2 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,879
    Thanks
    147
    Thanked 732 Times in 664 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
    157
    Thanks
    10
    Thanked 2 Times in 2 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
    8,866
    Thanks
    60
    Thanked 1,095 Times in 1,018 Posts
    And the formula is?

    cheers, Paul

  5. #5
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    3,341
    Thanks
    162
    Thanked 621 Times in 590 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
    157
    Thanks
    10
    Thanked 2 Times in 2 Posts
    Copy & Paste is my friend. Always has been.

  7. #7
    2 Star Lounger
    Join Date
    May 2011
    Posts
    157
    Thanks
    10
    Thanked 2 Times in 2 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,341
    Thanks
    162
    Thanked 621 Times in 590 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
  •