date format
 

I have a comstat workbook which has 52 worksheet tabs for all the weeks. I
have it linked to a workbook tha has one column set up with the beginning
date we use for the weeks. This workbook is formatted with custom mm-dd-yy
and it shows the month day and 07 for the year. In my originial workbook
something has happened and the cell that brings in that date now shows the
month-day-11 for the year. I cannot get the year to revert back to 07. I
went back in the date workbook and it shows it as 07, does anyone know why
the date on the original is showing the year as 11 instead of what is showing
on the other workbook?
Thanks,

date format
 

Sounds like this workbook might be using the 1904 date system. Check on the
Calculation tab.

That would change 2007 to 2011.

Regards

Trevor


"Pammy" wrote in message
...
I have a comstat workbook which has 52 worksheet tabs for all the weeks. I
have it linked to a workbook tha has one column set up with the beginning
date we use for the weeks. This workbook is formatted with custom
mm-dd-yy
and it shows the month day and 07 for the year. In my originial workbook
something has happened and the cell that brings in that date now shows the
month-day-11 for the year. I cannot get the year to revert back to 07. I
went back in the date workbook and it shows it as 07, does anyone know why
the date on the original is showing the year as 11 instead of what is
showing
on the other workbook?
Thanks,

date format
 

Just to add to Trevor's response...

One workbook was using a base year of 1900 and the other was using 1904.
(tools|options|calculation tab|1904 date system)

One way to add those four years back is to find an empty cell, put 1462 into
that cell.

Copy that cell.

Select your range that contains the dates.
Edit|PasteSpecial|Click Add (or Subtract) depending on which workbook you want
to fix.


You may have to reformat the cell as a date (mine turned to a 5 digit number).
But it should work.

You may want to do it against a copy...just in case.

Most windows users use 1900 as the base date. Mac users (mostly??) use 1904 as
the base date.

Pammy wrote:

I have a comstat workbook which has 52 worksheet tabs for all the weeks. I
have it linked to a workbook tha has one column set up with the beginning
date we use for the weeks. This workbook is formatted with custom mm-dd-yy
and it shows the month day and 07 for the year. In my originial workbook
something has happened and the cell that brings in that date now shows the
month-day-11 for the year. I cannot get the year to revert back to 07. I
went back in the date workbook and it shows it as 07, does anyone know why
the date on the original is showing the year as 11 instead of what is showing
on the other workbook?
Thanks,

--

Dave Peterson