View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Roger Govier Roger Govier is offline
external usenet poster
 
Posts: 2,886
Default 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