Forum Discussion
Historical dates in Excel (older than 01.01.1900)
Hi everybody
I am a teacher in History of technology and History of ideas. I recently found out that you are able to make visual timeline charts showing historical developments by using the Map...
You could try using the 1904 date system (File tab > Options > Advanced > When Calculating This Workbook), which seems to accommodate older dates. But it does so by adding some offset to the date, and it may mess up dates in other workbooks, and if you send a messed up workbook to someone else, it may mess up their dates. Maybe it's not as bad as all that, and it might be worth trying. But I don't really know how it works, and I've heard rumors....