• Write Us
  • Advertise
  • Copyright Policy
  • Privacy Policy
  • About
  • Contact

PC Tips and Tricks: Troubleshooting & Security | Techpraveen

  • Software
  • Tips
  • Security
  • Linux
  • Tricks
  • Troubleshooting
  • Freeware
  • Utilities
  • Easter Egg
  • Mac
You are here: Home / Tutorial / Excel Formula to calculate difference between two dates

Excel Formula to calculate difference between two dates

July 22, 2016 By Praveen Leave a Comment

Calculate Date Difference in Excel

Here is a simple tutorial to calculate the difference between two dates in Excel sheet. Count days before a date in excel using the simple formulas shown in this article. Some people want to calculate the days for the next birthday so continue reading this article.

If you had missed our earlier excel tutorials, please check the following

  1. What is the Keyboard Shortcut to Merge Cells in MS Excel?
  2. Complete List of Microsoft Excel Shortcut Keys
  3. How to Enable or Disable Cell Drag and Drop Editing Option in Ms Excel?
  4. How to Show Indian Currency Format in Excel?

What is TODAY Function ?

Using Today function in excel returns the serial number of the current date. The serial number is the date-time code used by Excel for date and time calculations. If the cell format was General before the function was entered, Excel changes the cell format to Date.

The TODAY function is useful when you need to have the current date displayed on a worksheet, regardless of when you open the workbook. It is also useful for calculating intervals.

=Date-Today()

In order to calculate the days before a certain date, all you need to do is subtract future date and later date. This can be achieved using TODAY() Function.

Excel Formula to calculate difference between two dates in Excel

Calculate difference between Future date and Today’s date

=B5-Today()

Now let’s see a simple formula to calculate the difference between future date and today’s date using TODAY Function. Here the cell B5 is future date and subtracting B5-Today’s date give the date difference in the cell D5.

Calculate difference between two dates without TODAY Function

=B6-C6

Calculating difference between two dates without using TODAY function is easy one. All you need to do is using the above formula to substrate the date present in 2 different cells.

Text Note to add along with Date Difference

="For your next birthday "& B7-C7 &" days left"

To calculate the number of days until your birthday in Excel, execute the formula shown above. Using the above concatenate formula you can use the text note along with date difference in excel sheet.

If you have any other formulas please share it in comment section.

  • Tweet
  • Share on Tumblr

Recommended Posts for You:

Praveen

I loving blogging & staying updated with latest Geek Stuffs. Website:www.geekyard.com

Leave a Reply Cancel reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Email Newsletter

Read latest Computer Tips & Tricks in your Inbox for Free!

Popular Articles

  • How To Watch 18+ Adult Videos on YouTube Without Logging In
  • How To Shutdown or Restart Mac OS X from Terminal?
  • Fix Your iTunes Store session has expired pop up message
  • Identify your iMac: Serial Number, Model Number and Technical Spec
  • I Love PDF: Merge and Split Your PDF Files Online
  • What is the Keyboard Shortcut to Merge Cells in MS Excel?
  • Outlook: How to Add Grid Lines Between Emails in Office 365
  • How to Fix Adobe Photoshop Stuck on Caps Lock
  • Portable Windows XP Live USB Edition 2008 v.2.02
Kaspersky Virus Removal Tool

Kaspersky Virus Removal Tool for Windows -Freeware

With Kaspersky Virus Removal Tool one can easily detect and removes viruses and other infections from the infected computer. Kaspersky provides various scan modes to find and

Cell Phone Spy App

Top Cell Phone Spy App of 2019

OneAre you looking for the top cell phone spy app of the year? The spy market is jam-packed with cell phone spy apps offering different features in a varying price range. This

Autonomous Car

Autonomous Cars and Why We Need Them

There is now automation and artificial intelligence integration in almost everything, which includes the manufacturing of the regular vehicles that we drive around today.Our

Defend Against a Cyberattack

How to Defend Against a Cyberattack

According to a recent report, 4.5 billion data records were breached in 2018 alone, and the number could potentially rise in 2019 and beyond.With cyberattacks becoming the

Quitting Google Chrome

Command + Q not working in Google Chrome – Mac Fix

Pressing Command + Q not working in Google Chrome. It shows "Hold ⌘Q to quit" pop up in Chrome browser. And I am unable to quit Google chrome browser. So, how to fix this

DMV Test Apps

Get Prepared for the DMV Test with The DMV Test Apps

Not everyone is great at taking tests, and that’s okay, I know I was never what you’d call a grade A student. The driver’s test can be especially stressful simply because so much

Facebook Fan Page

WordPress Speed Optimization

WordPress Speed Optimization


Slow WordPress site? I can make it load faster by optimizing images, configuring speed plugins, and using tools like W3 Total Cache to make it super fast. I will help you to increase GTmetrix Score at cheaper price. Contact me for Price details.

Advertise

Techpraveen Advertise

Promote your products easily by advertising with us.Head to Advertisement Page to avail Promotional Sale offer.

Find New Computer Tips & Tricks

Sitemap | Advertise | Privacy Policy | Copyright Policy | Contact Us

DMCA.com Protection Status