Difference of two dates

[Guest]

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

 

[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?

 

[Guest]

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

 

[Gord Dibben]

Check out Chip Pearson's site for info on DATEDIF Function.

http://www.cpearson.com/excel/datedif.htm


Gord Dibben MS Excel MVP