MS Excel stupidity
Jan. 16th, 2008 03:33 pm![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
howeirdIn Excel 2003 the date handler starts at January 1, 1900. Dates prior to 1900 cannot be sorted or arithmetically manipulated. Found this trying to build a spreadsheet showing birthdays of my grandparents, and computing how much older/younger they were than each other. Major WTF - the end date is the year 9999. One would think there is far more call to manipulate dates in the past than several millenniums into the future.
Yes, there are work-arounds, but they are ugly and defeat the purpose of a spreadsheet's date function.
Yes, there are work-arounds, but they are ugly and defeat the purpose of a spreadsheet's date function.
![[community profile]](https://www.dreamwidth.org/img/silk/identity/community.png){kind=small}