• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

Excel Tutorials

Microsoft Excel Tutorials

  • Home
  • Tutorials
  • Learn
    • Formulas
    • Power Query
    • Errors
    • Videos
    • Charts
    • Shortcuts
    • Pivot Tables
    • Macros
    • Basics
    • Analysis
  • 240+ Excel Shortcuts
  • Privacy Policy
You are here: Home / Formulas / How to get the number of days between dates in Excel?
How to get the number of days between dates in Excel?

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

posted on March 5, 2020

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?

Get-days-between-datesDownload

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

Filed Under: Formulas, Shortcuts Tagged With: calculate days between dates, days between dates, excel shortcut

Reader Interactions

Leave a Reply Cancel reply

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

Primary Sidebar

Download 240+ Shortcuts

Microsoft Excel comes with varieties of keyboard shortcuts which are stated below with excel shortcut name and its keys for Windows and Mac.

Categories

  • Basics
  • Formulas
  • Pivot Tables
  • Charts
  • Power BI
  • Analysis
  • Shortcuts
  • Macros
  • Add-Ins

Recent Comments

  • Olivia on Convert Formulas to Values in Excel
  • Pkv on How to Insert Comment In Power Query Steps?
  • Rahul on How to Insert Comment In Power Query Steps?
  • David on How to Insert Comment In Power Query Steps?
  • sofia on How to use Workday Formula in Excel?

Footer CTA

Get Weekly Updates in your mailbox

Get Started Now

Copyright © 2021