Sure, but I'm mainly talking about using a spreadsheet just as a spreadsheet. If you enter a bunch of mixed pre-/post-1900 dates into a column and then change the formatting to display as "DD-Mon-YYYY" everything will change except the pre- dates. There isn't really anything complicated needed to make that work, implementation-wise.
http://www.quirksmode.org/blog/archives/2009/04/making_time_...