I'm losing my fucking mind.

Why when I paste dates from one Excel file in a new one does it change the date? Like, from 7/31/05 to 8/1/09?? Reformatting doesn't seem to work.

And why have I come here for help? Because I rely on you.

i got nuthin.

I found this:

When I copy and paste dates, they end up four years wrong.

One workbook is using 1904 calendar, the other one 1900 (in the first example, years are not displayed, but definitely present). Go menu Tools>Options, Calculation and make them equal, preferably also correct if you know what the dates was supposed to be.

Excel is lame, like all MS Office software. (I do like MS Publisher though)

I have no alternative suggestions though.

You're welcome.

Are the dates just typed in order are they linked to something?

S'not what I heard!

The Tools > Calculator option makes no fucking sense, but I feel like your onto something. Please help more.

Shmoo, the date are formatted mm/dd/yy in the date column. There's nothing special about them.

FUCK THIS.

If you were alternating between Mac and Windows Excel, it might account for the date change. This is from the Microsoft:

How to Transfer Files Between Microsoft Excel for the Macintosh and Microsoft Excel for Windows

By default, Excel for the Macintosh uses the 1904 date system and Excel for Windows uses the 1900 date system. This means that when you type the serial number 1 in Excel for the Macintosh and format it as a date, Excel displays it as 1/2/1904 12:00 a.m. Excel for Windows displays the serial number 1 as 1/1/1900 12:00 a.m.

If you transfer files from Excel for the Macintosh to Excel for Windows, this difference in the date systems should not cause a problem, because the date system is stored in each file. However, if you copy and paste between files with different date systems that originated on different platforms, dates may be displayed four years and one day away from their correct date.

To change to the 1904 date system in Excel for Windows, follow these steps:
1. On the Tools menu, click Options.
2. Click the Calculation tab, and then select the 1904 date system check box.
To change to the 1900 date system in Excel for the Macintosh, follow these steps:
1. On the Tools menu, click Preferences.
2. Click the Calculation tab, and then clear the 1904 date system check box.

You're my favourite Canuck on the board.

Boo-yah!

I think wilked is some type of Excel semi-expert---you may want to send him a PM.

Problem solved. Headache persists, however.