B Brandon Moser May 6, 2004 #1 Can excel handle years before 1904? I am trying to do a historical chart that dates back to 1798. Thanks,
Can excel handle years before 1904? I am trying to do a historical chart that dates back to 1798. Thanks,
J JE McGimpsey May 7, 2004 #2 You can use the 1900 date system to go back to 1900 (Preferences/Calculation/1904 date system checkbox). For pre-1900 dates, see John Walkenbach's XDate add-in: http://j-walk.com/ss/excel/files/xdate.htm
You can use the 1900 date system to go back to 1900 (Preferences/Calculation/1904 date system checkbox). For pre-1900 dates, see John Walkenbach's XDate add-in: http://j-walk.com/ss/excel/files/xdate.htm
