Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Difference of two dates
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? In article , 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Difference of two dates
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Difference of two dates
Check out Chip Pearson's site for info on DATEDIF Function.
http://www.cpearson.com/excel/datedif.htm Gord Dibben MS Excel MVP On Mon, 4 Jun 2007 20:36:00 -0700, 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Difference between two dates | Excel Discussion (Misc queries) | |||
difference between dates | Excel Discussion (Misc queries) | |||
difference between dates | Excel Discussion (Misc queries) | |||
difference between dates | Excel Discussion (Misc queries) | |||
difference between two dates | Excel Discussion (Misc queries) |