How to subtract dates in excel
Calculating the difference between two dates in Excel doesn’t seem like much unless you try it. You are here, which means you already know the importance of calculating the date difference in excel. You cannot just write two dates and add a minus sign. It doesn’t work like that. The best way to do this correctly is to use function. There is a problem also. You can’t find this function listed in the formula tab. We are going to use the DatedIF Function in Excel. Usually, you get suggestions from Excel when you use functions, but not for this function. But don’t worry, I’ll walk you through. Check the article to learn the Dated if function thoroughly: msexceltutorial.com/post/How-...
Now let’s learn how to calculate the difference between two dates in Excel using the date if function. To subtract two dates in excel, we literally need two dates. Start date and end date. Now we need to write the formula. Remember, in Cell A1 I have a starting date and in Cell B1 I have an end date. Write the below formula to subtract dates in excel to get years:
=DatedIF (A1, B1, "Y")
To subtract dates to get months, write the below formula:
=DatedIF (A1, B1, "M")
Subtract dates to get days, then write the below formula.
=DatedIF (A1, B1, "D")
To find out the difference between two dates in Excel, you need to remember one thing. You must match the date format of your computer with the date format of your excel file. Otherwise, you’ll get a value error. This is how we calculate the difference between dates in excel.
#Substract #Date #Formula
Thanks for watching.
-------------------------------------------------------------------------------------------------------------
Support the channel with as low as $5
/ excel10tutorial
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial
goo.gl/uL8fqQ
Here goes the most recent video of the channel:
bit.ly/2UngIwS
Playlists:
Advance Excel Tutorial: goo.gl/ExYy7v
Excel Tutorial for Beginners: goo.gl/UDrDcA
Excel Case: goo.gl/xiP3tv
Combine Workbook & Worksheets: bit.ly/2Tpf7DB
All About Comments in Excel: bit.ly/excelcomments
Excel VBA Programming Course: bit.ly/excelvbacourse
Social media:
Facebook: / excel10tutorial
Twitter: / excel10tutorial
Blogger: excel10tutorial.blogspot.com
Tumblr: / excel10tutorial
Instagram: / excel_10_tutorial
Hubpages: hubpages.com/@excel10tutorial
Quora: bit.ly/3bxB8JG