Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dates Before 1900
I've downloaded a ShareWare Extended Dates Function Set thanks to MVP.org
which works with any dates -- including those BEFORE 1900 which Excel cannot handle. Works nicely. And I've seen the suggested VBA routine to calculate values using dates before 1900. I was wondering if anyone else had any other methods they've come across to handle this Excel shortcoming. Thanks for any tips and tricks. Janie |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dates Before 1900
Hi Janie,
Are you sure what you saw was shareware. Shareware is asking for payment. This one is certainly free. See John Walkenbach's page Extended Date Functions http://www.j-walk.com/ss/excel/files/xdate.htm --- HTH, David McRitchie, Microsoft MVP - Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Janie" wrote in message ... I've downloaded a ShareWare Extended Dates Function Set thanks to MVP.org which works with any dates -- including those BEFORE 1900 which Excel cannot handle. Works nicely. And I've seen the suggested VBA routine to calculate values using dates before 1900. I was wondering if anyone else had any other methods they've come across to handle this Excel shortcoming. Thanks for any tips and tricks. Janie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dates prior to 1900 in Excel | Excel Discussion (Misc queries) | |||
MS Excel should handle dates before 1900! | Excel Discussion (Misc queries) | |||
How can I get Excel 2003 to display dates before 1900 | Excel Discussion (Misc queries) | |||
graph dates revert to 1900 | Charts and Charting in Excel | |||
Need to sort dates before 1900 in proper order | Excel Discussion (Misc queries) |