ExcelBanter - entering dates

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - entering dates (https://www.excelbanter.com/excel-discussion-misc-queries/244976-entering-dates.html)

ownlee4me

entering dates

why does excel not except dates for calculations that are prior to 1900?

Mike H

entering dates

Hi,

Because Microsoft thinks the world began in 1900. If you want to use earlier
dates look here

http://j-walk.com/ss/excel/files/xdate.htm

Mike

"ownlee4me" wrote:

why does excel not except dates for calculations that are prior to 1900?

All times are GMT +1. The time now is 12:26 PM.