Answere #1:
=DATE(YEAR(A1)+58,MONTH(A1),DAY(A1))

Answere #2:
=DATEDIF(A2,TODAY(),"y")&" years, "&DATEDIF(A2,TODAY(),"ym")&" months,
"&DATEDIF(A2,TODAY(),"md")






"sajan chauhan" wrote:

Dear
Pl. give formula for the below mentioned example

For calculating Retirement date as completion year given 58yrs.
(Hired Date)-(Exact Retirement Date).
(01-Jan-07)-(??)
Above I required Exact Retirement date

Also for Birth calculation Difference date required
(Birth Date) (Todays Date)(Difference Date)
(20-Dec-78) (05-Jun-07) (??)
Above I required Exact Difference date as on today