Results 1 to 8 of 8
  1. #1
    Star Lounger
    Join Date
    May 2011
    Posts
    94
    Thanks
    6
    Thanked 1 Time in 1 Post

    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,635
    Thanks
    115
    Thanked 650 Times in 592 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
    Star Lounger
    Join Date
    May 2011
    Posts
    94
    Thanks
    6
    Thanked 1 Time in 1 Post
    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,186
    Thanks
    47
    Thanked 983 Times in 913 Posts
    And the formula is?

    cheers, Paul

  5. #5
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,826
    Thanks
    136
    Thanked 482 Times in 459 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
    Star Lounger
    Join Date
    May 2011
    Posts
    94
    Thanks
    6
    Thanked 1 Time in 1 Post
    Copy & Paste is my friend. Always has been.

  7. #7
    Star Lounger
    Join Date
    May 2011
    Posts
    94
    Thanks
    6
    Thanked 1 Time in 1 Post
    Got it working properly - don't know what I changed.

  8. #8
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,826
    Thanks
    136
    Thanked 482 Times in 459 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
  •