| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate difference in dates
I am trying to get a formula which calculates the difference of two dates in
dd/mm/yy format. Eg: I have 'Joining Date' and 'Resigned Date' in A1 & B1 respectievly. A B 1 28/05/1996 11/08/2008 = 15/03/12 (B1-A1),(Total no. of days worked is 4458) whereas the correct answer is 14/02/12. I tried the formula DATEDIF(C6,D6,"md")&"/"&DATEDIF(C6,D6,"ym")&"/"&DATEDIF(C6,D6,"y"); I got the answer as'14/2/12', but the total working days is different which is not relevent for further calculations. Please help..... -- Geo |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I calculate exact difference between two dates in y,m,d. | Excel Worksheet Functions | |||
| How do I calculate exact difference between two dates in y,m,d. | Excel Worksheet Functions | |||
| How do I calculate the difference between 2 dates (m,d,y) ? | Excel Worksheet Functions | |||
| Calculate Difference b/e 2 dates. | New Users to Excel | |||
| Calculate difference between two dates | Excel Worksheet Functions | |||
Threaded Mode
