Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I calculate exact difference between two dates in y,m,d.
I want to calculate the difference between two dates exactly in years, months
and days. Say between the dates 14-02-1980 to 28-02-1985. The difference is 5 years, 0 months and 14 days including both the starting and ending dates. But excel does not give the exact answer. Pl help me. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I calculate exact difference between two dates in y,m,d.
Hi Muhammad,
use the datedif function =datedif(initial_date,final_date,"X") X is "Y" to see the diference in years "M" to see the diference in months "D" to see the diference in days "MD" to see the diference but, months and years are ignorated "YD" to see the diference but, days and years are ignorated hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Muhammad Javaid Hassan" escreveu: I want to calculate the difference between two dates exactly in years, months and days. Say between the dates 14-02-1980 to 28-02-1985. The difference is 5 years, 0 months and 14 days including both the starting and ending dates. But excel does not give the exact answer. Pl help me. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I calculate exact difference between two dates in y,m,d.
Assuming that A2 contains the first date, and B2 contains the second,
try... =DATEDIF(A2,B2,"y") =DATEDIF(A2,B2,"ym") =DATEDIF(A2,B2,"yd") Hope this helps! In article , Muhammad Javaid Hassan <Muhammad Javaid wrote: I want to calculate the difference between two dates exactly in years, months and days. Say between the dates 14-02-1980 to 28-02-1985. The difference is 5 years, 0 months and 14 days including both the starting and ending dates. But excel does not give the exact answer. Pl help me. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I calculate exact difference between two dates in y,m,d.
Correction...
=DATEDIF(A2,B2,"yd") should be =DATEDIF(A2,B2,"md") Hope this helps! In article , Domenic wrote: Assuming that A2 contains the first date, and B2 contains the second, try... =DATEDIF(A2,B2,"y") =DATEDIF(A2,B2,"ym") =DATEDIF(A2,B2,"yd") Hope this helps! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula to obtain difference between two dates. | Excel Worksheet Functions | |||
difference between dates | Excel Discussion (Misc queries) | |||
Formula to calculate number of days between Dates | Excel Worksheet Functions | |||
Difference between two dates in months with decimals | Excel Worksheet Functions | |||
calculate with dates before 1-1-1900 | Excel Worksheet Functions |