How to Calculate the Difference Between Two Dates​ in Excel

Learn how to subtract and add dates in this step-by-step tutorial using Microsoft Excel. With subtraction, find out how many days are in between two dates. With addition, find out what date you'll land on by adding days to a date.

As full-disclosure, I work at Microsoft as a full-time employee.

[michelemcarthur]

Absolutely fantastic! To the point and easy to understand. I'd like to see how you would calculate dates with exceptions. Formulas which calculate daily fees excluding a particular day and holidays.

[aung]

I have been searching about calculation of probation period of a staff. Now, I've found it. You're the BEST teacher I've ever met. A million thanks to you.

[shadaksharicr]

I happen to see videoo on your birthday...so. Happy Birthday to Kevin

[sarwarmuhamad]

Thank you for the beautiful explanation

[DROIDFARM]

THANK YOU! This was great! Liked and subscribed!

[miteshdhage]

Very nice content and perfect explanation. Loved you video alot it a playlist of its own. ❤️

[nanjr]

didt know about 01.01.1990. thats cool. now i know why it shows the number when i change the date format to number format. thank you so much

[bpkingcobra]

This is exactly what I was looking for - Thank you for this vid!

[God-dtom]

nope... still get error values... so frustrating. even when I change the values it wont change some cells...

[leviv]

I am getting #value! error... what am I doing wrong?

[prosperityfocus]

Hi Kevin, you are an AMAZING instructor. I am new to excel and I'd like to know if I can use excel to create a software (what formula) to populate answers for predetermined data subjects. I am not sure if I explain correctly here but here's an example. Under the "Subject" data, I have "Non-Existence" with bullet points 1. DC, 2. NP (these letters stand for a paragraph). And then there will be a "Goal" and "Result" button. Under "Result", I want to calculate/bring specific answers bullet points from the "Subject" data based on the conditions under "Goal." I hope this means sense to you and thank you for your help.

[jenniferk]

Times almost up! Your birthday is now TOMORROW! 🤩 Enjoy the day.
Related future content request: my line of business needs to calculate age in whole years, and never round up. E.g. Age 25.79 should just be age 25. Thank you!

[munecaify]

Hi I like watching your videos they are very helpful, I need to know how to creat a list where the dates change automatically from week by week for a time sheet.

[olasogbadotun]

Tomorrow's your birthday?
Happy Birthday in advance, Kevin.

[robertlamble]

Microsoft employee with Chrome on the Taskbar?

[michellea.]

Hi there - Thank you for a great video!
Question/request: I would like have the a date interval repeated 4 times the automaticall update. Is that possible?
For example - I want the column to say 07/2/2023 - 07/08/2023 times 4 rows then update to the next week's interval.

[birgerkagan]

Tried the Today() and Now() functions - both returned a "name"-error

[douglasgaylor]

How would you calculate, the average role length, if you had multiple roles and within each role you had multiple contracts with different start and end dates?

[Tesnobay]

Hi, in the cell for the date Toothbrush Installed, shouldn't the date be hard coded instead of =now(), because the date will change everyday you reopen it, and the formula below it will just add 90 to the new date?

[sathapeer]

Hi
I have a question?
Like if we have to just calculate the no of calendar days from the start date to end date including the dates I am giving e.g start date is 24/02/2020 and the end date is 29/02/2020 typically if we calculate it on fingers it will come up with 6 days and if we give a simple formula (end-date - start date) it comes up with the answer 5 days. How can I calculate it with the correct number of days?
Hope I am clear with my question if not, please reply so that I can elaborate further.
Thanks