jo
john walkenbach has an addin to help with per-1900 dates.

http://spreadsheetpage.com/index.php...nctions_xdate/

regards
FSt1

"Excelfan" wrote:

Is it there a way to substract 2 cells with different dates and get a result
in year,months and days.
WAIT! not that easy:
The second date (B1) could be today or close as in 1900, 2000...
The first date(A1), that's the one giving me the problem
because it could be in 1776, 1492 etc.
THANKS.