How To Calculate Difference Between 2 Dates In Excel (Years, Months, Days)

In this tutorial, I’m going to show you how to calculate the difference between two dates in Microsoft Excel. I will show you how to calculate the number of days, months and years between the two dates.
HOW I CREATED THIS TUTORIAL (AFFILIATE LINKS)
Screen recorder & editor techsmith.z6rjha.net/c/198849...
UA-cam SEO www.tubebuddy.com/SHTeach
Software (Microsoft Excel 365 ProPlus)
FOLLOW US
Website toptipbio.com/
Facebook / toptipbio
Twitter / toptipbio
AFFILIATE DISCLAIMER
Some of the above links are affiliate links, meaning I will earn a commission if a sale is made after clicking on the link.

[@rishabkumar6393]

Very informative bro thanku respect 🫡 from india 🇮🇳

[@vaibhavsrivastava7945]

thankyou sir very help full video

[@PiduguVijay]

thanks for the video

[@write2kishore]

Thank you very much

[@noelgibson]

is there a way to copy and paste something that would work for multiple dates for example multiple people for years of service

[@johnnychcr]

The formula used is not recognized since office 2016, completely outdated.

[@AnimeFusionUpdatesz]

What about Days360

[@tabs9332]

DATED IF no longer works on MS 365 updates. If it works for you still, then great. But no longer working on most. The video is outdated.

[@isaiahjones6073]

What do you use instead?

[@jasonfitt]

It doesn't even come up as an option when I type =DATEDIF in a cell

[@tabs9332]

@@jasonfitt I managed to overcome this after a couple days. My excel somehow reverted back to normal and DATEDIF returned.
I think it has something to do with the excel file itself maybe. But it’s come back since this post was made.

[@nxtgen5393]

@@jasonfitt Yes, but it will still work

[@AnimeFusionUpdatesz]

can I use Days360 instead?​@@tabs9332