Hi Luciano,

Am Thu, 18 Jul 2013 10:45:10 -0700 (PDT) schrieb Luciano:

I understood that, But in my case I do not have spaces in front of the date number. When one date felt on an year and the other date on another year the calculation display negative values instead the number of years, like:
Calendar Date Adapted Years Month Days Hours Minutes
-1999-Jun-25 6/25/2399
-1999-Nov-21 11/21/2399 0.408 4.895 149 3576 214560
-1997-May-06 5/6/2397 -2.543 -30.522 -929 -22296 -1337760

you have to test whether B3B2 or B3<B2
Have another look I changed the formulas


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2