Date calculations before 1900 do not work

[Michael Cook]

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.

 

[Paul B]

Michael, have a look here

http://j-walk.com/ss/excel/usertips/tip028.htm
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003