How to calculate with years....?
Hi
One way
=YEAR(TODAY())-YEAR(A1)
or
=DATEDIF(a1,TODAY(),"y")
--
Regards
Roger Govier
"Andrew" <NoToSPAM@home wrote in message
...
How to calculate with years...
IE: Date in Cell(A1) 16/12/1993
Value in B(1)= 12 (Years)
should give date 16/12/2005
-------------------
TIA
Andrew
|