dates vary in a copied sheet

  • Thread starter Thread starter Jeannie
  • Start date Start date
J

Jeannie

emailed a file and dates on sheet they see are exactly 1 day and 4 years
earlier than actual dates shown on my sheet.
 
Jeannie

Sounds like you are on the 1904 date system. This can be changed by either
you or the recipient of your workbook at (pre 2007) Tools>options>calculation
tab & change the setting for th 1904 date system. This change will affect
otgher workbooks, so be careful.

Mike Rogers
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Remove date format? 3
Excel Formula - Count Dates from another Sheet 8
Help to create a macro 2
Excel VBA to go to specific sheet & cell in the current workbook not working. 2
Excel How to get the number of days an item was opened from the today's date. 14
Copy Sheet to new Sheet and clear cells on original sheets 7
Excel VBA to move cells to sheet2 based on selection in sheet1 0
Excel Is this possible?? 3

Back
Top