On Sat, 20 Oct 2007 14:00:23 -0700, Gord Dibben <gorddibbATshawDOTca
sayd the following:

Just because it is formatted as a date doesn't mean it is a date.

When you change column A format to General what do you see?

If real dates you should see 5-digit numbers like

33298
33025
22098
26115
30498

Do you get numbers from the =MONTH() formula as I did in column B?



I see 5 digit numbers as you do.