How to incorporate dates prior to 1900 in Excel formulas
Posted on 2013-05-29
Since Excel's date system does not include serial numbers for dates prior to 1900, is there a good way to specify these dates so that they can be used in calculations?
The only method I have found is to add some fudge factor such as 2000 to the year (e.g. 2013 would be 4013) whenever the year is required in a formula and then subtract the value of that fudge factor back out in the answer.
However, that can get a bit confusing so it would be nice if there is a way to do it without the fudge factor.