Hi,

I'd go with this addin

http://www.j-walk.com/ss/excel/files/xdate.htm

Mike

"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.