Results 1 to 8 of 8
  1. #1
    2 Star Lounger
    Join Date
    May 2011
    Posts
    135
    Thanks
    9
    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,790
    Thanks
    139
    Thanked 705 Times in 639 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
    135
    Thanks
    9
    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,689
    Thanks
    59
    Thanked 1,065 Times in 990 Posts
    And the formula is?

    cheers, Paul

  5. #5
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    3,188
    Thanks
    152
    Thanked 591 Times in 561 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
    135
    Thanks
    9
    Thanked 2 Times in 2 Posts
    Copy & Paste is my friend. Always has been.

  7. #7
    2 Star Lounger
    Join Date
    May 2011
    Posts
    135
    Thanks
    9
    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,188
    Thanks
    152
    Thanked 591 Times in 561 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
  •