Calculate Difference in Years, Months and Days between Two Dates

This tutorial shows you how to calculate the number of years, months and days between two dates using the undocumented DATEDIF function in Excel
------------------------

[umashankar]

This is simple awesome. You have give great solution which I was searching from long time. Thank you so much...!!! From Bengaluru, Karnataka (INDIA)

[Jojosmith]

Greatest Excel formula teacher as all time. Thanks a lot Chester for your valuable tutorial. Thumbs up. Already subscribed 👍

[JasvinderSingh-tpch]

the ever best formula i have seen for calculating years months and dates, and so nicely explained

[NemoOfNautilus]

Best video I could lay my hands on in this context, thanks Chester, appreciate it.

[darussalam]

best video seriously. helped my sister in law big time. lol

[atullotlikar]

Wonderfully explained. Helped immediately or else would have had to go through manually doing it. Thank you very much.

[devilhascomeagain]

Thank you.. This helped. Your explanation was quite easy to understand!!
I wanted to get the employee tenure, hence modified the formula
=DATEDIF(A5, TODAY(), "y")&" Years " &DATEDIF(A5, TODAY(), "YM")&" Months"
where Column A has the Employee joining date.

[ChitayMach]

Excellent, very helpful, Muchisimas gracias

[ronalddcunha]

Very useful & handy formula.... thank you very much

[ta-jayrussell]

Thank you ever much this was very helpful. I love this video

[sanjeevthakali]

explained in a simple language...
thank you sir

[narayan]

Thank you very much Sir, for your support and guidance always.

[rehansiddique]

thank you, very helpful and well explained,

[saghiiee]

Hi great teaching. I am trying to use if function with dates if. Like if the difference between class date and todays date is greater than 42 then give me a return value of greater than 6 weeks but if it is grater then 8 weeks return a result of Outlaw. How can I go about this?

[Raw]

This was very informative. One question. After calculating these dates using the DateDif function, how would I go about dividing the result by ½ ?

[MrEDP]

Great video and definitely very useful.. I do have a question. I'm a military leader and have to produce yearly evaluations on specific personnel with different start dates. Example: If I have a Soldier that is promoted to Sgt, that Soldier is due an evaluation one year from the date of promotion. The number of Soldiers I have in this category is overwhelming and hard to track if I don't have a reminder. I would like to create a formula that will act as a countdown to the due date. I'd appreciate all the help I can get. Thanks

[paulsanjaysurisetty]

@Chester Tugwell Thank you very much for this video sir :) It is really helpful, I was really struggling to do this manually from past six years. Your video solved my problem in seconds.... I am really really happy for this ... Thank you once again

[tiamhokwee]

Thanks, for your formula, but could you please help me how to calculate two dated for example started 1/1/1892 and until today date.

[ajeeshization]

When i use the formula in Excel 2010, i am getting the result as #NUM!. Why do i get the result like that?

[edgegardom]

got it! d order of d dates should be... dd/mm/yyyy.... THANKS. nid dis 4 my pupils