dates

[excelguy]

I want to write march 22, 3760 BCE in excel. I know dates before 1/1/1900 can
be written as numbers but I don't know how to make the BCE dates into
numbers. Any ideas? thanks

 

[joel]

Treat the data as a string by putting a single quote finfront of the data.

'march 22, 3760 BCE


Excel doesn't work with negative dates (before 1/1/1900). You get into a
lot of problems with dates before 1900 because the calendar was changed a lot
of times. In the 1700's they actually move the calendar from April to
February because if was still snowing heavly in May and then adding a leap
day to the calendar. the calendar was established in the 1500's and missing
leap days for 200 years the calendar was off 50 days.