Mister Eclectic (howeird) wrote,
Mister Eclectic
howeird

  • Mood:

MS Excel stupidity

In 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.
Subscribe

  • Yup, Canceled. Not just postponed

    Usually every other week on Wednesdays afternoon the highlight of the week is my 1-on-1 with the boss. He's not just the boss, we're also friends, we…

  • I Are Mechanically inclined

    Up at 7:30, did my usual morning stuff except only took half a cooler of snacks. Out the door at 9, the street was wet, there were dark clouds…

  • Am I Blue?

    After the latest Windows update the PC bluescreened. Had to go to safe mode/no network and do a system restore to last week. Seems to be working now.…

  • Post a new comment

    Error

    Anonymous comments are disabled in this journal

    default userpic

    Your reply will be screened

    Your IP address will be recorded 

  • 0 comments