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:
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:
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!
Then we will select the project end date, as shown in the image above.
After that we will put the “minus” sign.
Then last but not the least, we will select the project start date.
Now, press “enter” to hear the BAAAMMMM as a background effect.
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.
Now all you have to do is go to the bottom right corner of your cell and drag it down!
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!
So, it’s easy, isn’t it?
Learn more : Add the Calculator to the Excel Toolbar
Leave a Reply