View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sajan chauhan sajan chauhan is offline
external usenet poster
 
Posts: 2
Default Difference of two dates

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