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
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:
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.
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.
=C2-B2
And instantly, you will see the answer in the cell where you typed the formula.
You’re all set. Did you know that in addition to subtracting dates, you can also add dates together in Excel?
Calculate the Days Between Two Dates With the DAYS Function
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.
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.
=DAYS(C2,B2)
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:
=DAYS("27/7/2021","25/3/2021")
And immediately, Excel will tell you the number of full days between your 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.
Note: This article have been indexed to our site. We do not claim legitimacy, ownership or copyright of any of the content above. To see the article at original source Click Here
Amazon Basics Dog and Puppy Pee Pads with 5-Layer Leak-Proof Design and Quick-Dry Surface for Potty Training, Heavy Duty Absorbency, X-Large, 28 x 34 Inch - Pack of 25, Blue & White
$17.55 (as of January 31, 2025 19:28 GMT +00:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
Turmeric Kojic Acid Cleansing Pads - Turmeric Face Scrub Pads with Vitamin C (30 pads), Kojic Acid and Turmeric Cleansing…
$34.99 (as of January 31, 2025 19:24 GMT +00:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
CRZ YOGA Butterluxe High Waisted Lounge Legging 25" - Buttery Soft Workout Yoga Pants for Women
$32.00 (as of February 1, 2025 20:02 GMT +00:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
KINGBOLEN Ediag Elite OBD2 Scanner Bluetooth, Bi-Directional Control Scanner All System Diagnostic Tool for…
$109.99 (as of January 31, 2025 19:24 GMT +00:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
![We Asked a NASA Scientist: What’s It Like Landing on Mars? [Video] thumbnail](https://scitechdaily.com/images/Mars-Perseverance-Landing.gif)
