Displaying date across a workbook in EXCEL

Topic

New Reply

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?

Reply | Quote

Replies

mmi16,

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

Reply | Quote

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.

Reply | Quote

And the formula is?

cheers, Paul

Reply | Quote

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

Reply | Quote

Copy & Paste is my friend. Always has been.

Reply | Quote

Got it working properly – don’t know what I changed.

Reply | Quote

Hi mmi16

A change is as good as arrest.

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

zeddy

Reply | Quote