ExcelBanter - Date calculations before 1900 do not work

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Date calculations before 1900 do not work (https://www.excelbanter.com/excel-worksheet-functions/9709-date-calculations-before-1900-do-not-work.html)

Michael Cook

Date calculations before 1900 do not work

I'm using dates prior to 1900 in my history research and needing to do
calculations.
Excel Functions like YEAR do not work with these early dates. Is there a
fix for this or a way around the problem.
Many thanks for any help.

All times are GMT +1. The time now is 02:55 AM.