How to Find the Number of Days Between Two Dates in Microsoft Excel

Join 425,000 subscribers and get a daily digest of news, geek trivia, and our feature articles.
By submitting your email, you agree to the Terms of Use and Privacy Policy.
Mahesh Makvana is a freelance tech writer who specializes in writing how-to guides. He has been writing tech tutorials for over a decade now. He’s written for some of the prominent tech sites including MakeUseOf, MakeTechEasier, and Online Tech Tips. Read more…
Microsoft Excel logo on a green background
Microsoft Excel makes it easy to count the number of full days between two specific dates. You can use either an arithmetic operator or an Excel function to do that. We’ll show you both ways.
RELATED: How to Count the Days Between Two Dates in Google Sheets

Find the Number of Days Between Dates With Subtraction
Calculate the Days Between Two Dates With the DAYS Function

To know how many days there are between two days with the – (minus) sign method, first, open your spreadsheet with Microsoft Excel.
We will use the following spreadsheet which has both a start date and an end date:
An Excel spreadsheet with a start and an end date.
It should happen automatically, but make sure the text for your dates is formatted as date values.
In your spreadsheet, click the cell in which you want to display the answer. This cell will show the number of days between your specified dates.
Click the cell in which to display the result.
In your selected cell, type the following formula and press Enter. In this formula, replace C2 with the cell where you have your end date, and replace B2 with the cell where you have your start date.
Enter the formula to find the number of days between two dates.
And instantly, you will see the answer in the cell where you typed the formula.
The number of days between the specified dates.
You’re all set. Did you know that in addition to subtracting dates, you can also add dates together in Excel?
Excel’s DAYS function is dedicated to finding the number of days between two dates. It effectively performs the same calculation that the subtraction method does, so it’s up to you which method you use.
To use this function, open a spreadsheet with Microsoft Excel. In the spreadsheet, click the cell in which you want to display the answer.
Click the cell in which to display the result.
In your selected cell, type the following function and press Enter. In this function, replace C2 with the cell where you have your end date, and replace B2 with the cell where your start date is.
Enter the DAYS function.
If you’d like to use the dates directly in the function, you can do so. In this case, in the above function, replace C2 with the end date and B2 with the start date. Make sure to add double quotes around each date.
Like this:
Enter the DAYS function with direct values.
And immediately, Excel will tell you the number of full days between your specified dates.
Days between the two specified dates.
Now that you know this, you might also want to learn how to calculate someone’s age in Excel. It’s equally easy to do that.
RELATED: How to Calculate Age in Microsoft Excel
JOIN GEEK TALK ON FACEBOOK
Facebook
Instagram
Twitter
LinkedIn
RSS Feed
The Best Free Tech Newsletter Anywhere
By submitting your email, you agree to the Terms of Use and Privacy Policy.

source

Digital Strategist Chris Hood

Leave a Reply

Your email address will not be published. Required fields are marked *

© 2022 SHAQ HAX - Proudly powered by theme Octo