Difference of two dates

S

sajan chauhan

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
 
J

JE McGimpsey

What does "given 58yrs" mean - that the retirement date is 58 years
after hire? That doesn't seem right...

For your Birth calculation Difference date, what form do you want it in
- years? days?
 
T

Teethless mama

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")
 
Top