These Either return:
Sat-14/Apr/1900
Or
105

Not.... 16/12/2005 ....?

Sorry Roger your Not answering the question.
Thanx for trying though.


"Roger Govier" wrote in message
...
| 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
|
|
|
|