Has it ever happened to you that you are working on a project and you want to count the total number of days, you were working on the same? But then it becomes nearly impossible due to the month math or the fact that we are not very great in counting!

Previously: How to sort Blank Data with SUMIF formula in excel?

So, here’s a solution:

How to get the number of days between dates in Excel? 1

As you can observe in the image above, we have taken a bunch of dates that are mentioned under the column heading – “Project start date” and “Project end data” and to make it look professional, we have added the Product Id as well to make you feel that we are some smart geniuses who have worked on a bunch of projects till now.

Anyways, moving on, to know the no. of days, this is what we do:

How to get the number of days between dates in Excel? 2

Always remember a formula or a solution will only be brought out in excel if you put the “equal to” sign. Basically, it is the indicator for excel that the person is going to ask for answers now so be prepared!

How to get the number of days between dates in Excel? 3

Then we will select the project end date, as shown in the image above.

How to get the number of days between dates in Excel? 4

After that we will put the “minus” sign.

How to get the number of days between dates in Excel? 5

Then last but not the least, we will select the project start date.

Now, press “enter” to hear the BAAAMMMM as a background effect.

How to get the number of days between dates in Excel? 6

Here’s your answer on the screen, i.e. 77 days on a project that started on 5 June, 2017 and ended on 21 August 2017.

How to get the number of days between dates in Excel? 7

Now all you have to do is go to the bottom right corner of your cell and drag it down!

How to get the number of days between dates in Excel? 8

And TADAAAAA!!! You have your number of days out of the project start and end date. You are saved from the weird mathematic calculations and a bit of embarrassment!

How to get the number of days between dates in Excel? 9

So, it’s easy, isn’t it?

Learn more : Add the Calculator to the Excel Toolbar