Easily Calculate the Number of Days Between Two Dates in Microsoft Excel

PDF download Download Article

3 methods for finding the number of days between dates in Excel

PDF download Download Article

Trying to find how many days there are between two dates in Excel? There are a few easy methods for doing so! You can use the DATEDIF or DAYS functions. Or, just subtract the two dates! This wikiHow guide will show you how to calculate the number of days between two dates in Microsoft Excel.

Things You Should Know

  • Use =DATEDIF(start_date, end_date, "d") to find the difference in days between two dates.
  • Or, Use DAYS(end_date, start_date) to calculate the days between two dates.
  • Alternatively, subtract the two dates using the subtraction operator (-).
Method 1
Method 1 of 3:

Using the DATEDIF Function

PDF download Download Article
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/92\/Calculate-Number-of-Days-Between-Two-Dates-in-Excel-Step-1-Version-3.jpg\/v4-460px-Calculate-Number-of-Days-Between-Two-Dates-in-Excel-Step-1-Version-3.jpg","bigUrl":"\/images\/thumb\/9\/92\/Calculate-Number-of-Days-Between-Two-Dates-in-Excel-Step-1-Version-3.jpg\/v4-728px-Calculate-Number-of-Days-Between-Two-Dates-in-Excel-Step-1-Version-3.jpg","smallWidth":460,"smallHeight":342,"bigWidth":728,"bigHeight":541,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    For example, you could put 1/10/2023 in cell A1. The DATEDIF function calculates the difference between two dates in days, months, or years. [1]
    • If you’re searching for a specific date in a large dataset, try using the VLOOKUP function .
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/a7\/Calculate-Number-of-Days-Between-Two-Dates-in-Excel-Step-2-Version-3.jpg\/v4-460px-Calculate-Number-of-Days-Between-Two-Dates-in-Excel-Step-2-Version-3.jpg","bigUrl":"\/images\/thumb\/a\/a7\/Calculate-Number-of-Days-Between-Two-Dates-in-Excel-Step-2-Version-3.jpg\/v4-728px-Calculate-Number-of-Days-Between-Two-Dates-in-Excel-Step-2-Version-3.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":547,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    For example, 1/17/2023 in cell A2.
    Advertisement
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/a3\/Calculate-Number-of-Days-Between-Two-Dates-in-Excel-Step-3-Version-3.jpg\/v4-460px-Calculate-Number-of-Days-Between-Two-Dates-in-Excel-Step-3-Version-3.jpg","bigUrl":"\/images\/thumb\/a\/a3\/Calculate-Number-of-Days-Between-Two-Dates-in-Excel-Step-3-Version-3.jpg\/v4-728px-Calculate-Number-of-Days-Between-Two-Dates-in-Excel-Step-3-Version-3.jpg","smallWidth":460,"smallHeight":347,"bigWidth":728,"bigHeight":549,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    For example, this formula could be in A3. Replace A1 and A2 with the cells containing the start and end dates. This will find the number of days between cells A1 and A2. You’ll see the result in the cell you selected for the function.
    • The first parameter (A1) is the start date, and the second parameter (A2) is the end date.
    • Replace "d" with "m" to find the difference in months or "y" to find the difference in years.
    • Copy this formula as needed and paste it next to other dates you’re trying to find the difference between.
    4. Advertisement
Method 2
Method 2 of 3:

Using the DAYS Function

PDF download Download Article
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/fb\/Calculate-Number-of-Days-Between-Two-Dates-in-Excel-Step-4-Version-3.jpg\/v4-460px-Calculate-Number-of-Days-Between-Two-Dates-in-Excel-Step-4-Version-3.jpg","bigUrl":"\/images\/thumb\/f\/fb\/Calculate-Number-of-Days-Between-Two-Dates-in-Excel-Step-4-Version-3.jpg\/v4-728px-Calculate-Number-of-Days-Between-Two-Dates-in-Excel-Step-4-Version-3.jpg","smallWidth":460,"smallHeight":342,"bigWidth":728,"bigHeight":541,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    For example, you could put 1/10/2023 in cell A1. The DAYS function calculates the number of days between dates. [2]
    • This function is useful for plenty of applications! For example, if you’re tracking your bills in Excel , you can calculate the days between two dates to average your per-day spending.
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/6d\/Calculate-Number-of-Days-Between-Two-Dates-in-Excel-Step-5-Version-3.jpg\/v4-460px-Calculate-Number-of-Days-Between-Two-Dates-in-Excel-Step-5-Version-3.jpg","bigUrl":"\/images\/thumb\/6\/6d\/Calculate-Number-of-Days-Between-Two-Dates-in-Excel-Step-5-Version-3.jpg\/v4-728px-Calculate-Number-of-Days-Between-Two-Dates-in-Excel-Step-5-Version-3.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":547,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    For example, 1/17/2023 in cell A2.
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/6b\/Calculate-Number-of-Days-Between-Two-Dates-in-Excel-Step-6.jpg\/v4-460px-Calculate-Number-of-Days-Between-Two-Dates-in-Excel-Step-6.jpg","bigUrl":"\/images\/thumb\/6\/6b\/Calculate-Number-of-Days-Between-Two-Dates-in-Excel-Step-6.jpg\/v4-728px-Calculate-Number-of-Days-Between-Two-Dates-in-Excel-Step-6.jpg","smallWidth":460,"smallHeight":342,"bigWidth":728,"bigHeight":541,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    For example, this formula could be in A3. Replace A2 and A1 with the cells containing the start and end dates. This will find the number of days between cells A1 and A2. You’ll see the result in the cell you selected for the function.
    • The first parameter (A2) is the end date, and the second parameter (A1) is the end date. This is opposite the order of the DATEDIF function.
    4. Advertisement
Method 3
Method 3 of 3:

Using Subtraction

PDF download Download Article
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/a3\/Calculate-Number-of-Days-Between-Two-Dates-in-Excel-Step-7.jpg\/v4-460px-Calculate-Number-of-Days-Between-Two-Dates-in-Excel-Step-7.jpg","bigUrl":"\/images\/thumb\/a\/a3\/Calculate-Number-of-Days-Between-Two-Dates-in-Excel-Step-7.jpg\/v4-728px-Calculate-Number-of-Days-Between-Two-Dates-in-Excel-Step-7.jpg","smallWidth":460,"smallHeight":342,"bigWidth":728,"bigHeight":541,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    For example, you could put 1/10/2023 in cell A1. You can use the subtraction operation (-) to find the days between two dates.
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/8c\/Calculate-Number-of-Days-Between-Two-Dates-in-Excel-Step-8.jpg\/v4-460px-Calculate-Number-of-Days-Between-Two-Dates-in-Excel-Step-8.jpg","bigUrl":"\/images\/thumb\/8\/8c\/Calculate-Number-of-Days-Between-Two-Dates-in-Excel-Step-8.jpg\/v4-728px-Calculate-Number-of-Days-Between-Two-Dates-in-Excel-Step-8.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":547,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    For example, 1/17/2023 in cell A2.
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/f1\/Calculate-Number-of-Days-Between-Two-Dates-in-Excel-Step-9.jpg\/v4-460px-Calculate-Number-of-Days-Between-Two-Dates-in-Excel-Step-9.jpg","bigUrl":"\/images\/thumb\/f\/f1\/Calculate-Number-of-Days-Between-Two-Dates-in-Excel-Step-9.jpg\/v4-728px-Calculate-Number-of-Days-Between-Two-Dates-in-Excel-Step-9.jpg","smallWidth":460,"smallHeight":348,"bigWidth":728,"bigHeight":551,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    For example, this formula could be in A3. Replace A2 and A1 with the cells containing the start and end dates. This will find the number of days between cells A1 and A2. You’ll see the result in the cell you selected for the function.
    • Using the SUM function is less useful for dates. Since dates are stored as serial numbers in Excel, SUM would just add those numbers together.
    4. Advertisement

Expert Q&A

Search
Add New Question
  • Question
    What is the formula to do a count down in days in a cell in Excel? Can I have the font turn red on day 0?
    Kyle Smith
    wikiHow Technology Writer
    Kyle Smith is a wikiHow Technology Writer, learning and sharing information about the latest technology. He has presented his research at multiple engineering conferences and is the writer and editor of hundreds of online electronics repair guides. Kyle received a BS in Industrial Engineering from Cal Poly, San Luis Obispo.
    Kyle Smith
    wikiHow Technology Writer
    Expert Answer
    You can use =DAYS(A1,TODAY()) to make a countdown in days. Replace "A1" with the cell that contains the date you're counting down to. To make the font turn red on day 0, select the cell with the DAYS formula. Go to the Home tab > Conditional Formatting > New Rule. Click "Format only cells that contain." Change "between" to "equal to" in the drop down menu. Enter 0 to the right of "equal to." Click "Format" and change the Font color to red. Click OK on both windows to confirm the change.
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 0 Helpful 0
  • Question
    how to calculate no.of.days between two dates without mentioning the date in any cells/columns
    Kyle Smith
    wikiHow Technology Writer
    Kyle Smith is a wikiHow Technology Writer, learning and sharing information about the latest technology. He has presented his research at multiple engineering conferences and is the writer and editor of hundreds of online electronics repair guides. Kyle received a BS in Industrial Engineering from Cal Poly, San Luis Obispo.
    Kyle Smith
    wikiHow Technology Writer
    Expert Answer
    You can input the start and end dates as text in the DAYS function to calculate the number of days without needing to reference another cell. For example, =DAYS("4/15/2023","4/1/2023") would return the number of days between 4/15/2023 and 4/1/2023.
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 1 Helpful 1
  • Question
    How many days between 22 June 2019 and 10 Jan 2020?
    Kyle Smith
    wikiHow Technology Writer
    Kyle Smith is a wikiHow Technology Writer, learning and sharing information about the latest technology. He has presented his research at multiple engineering conferences and is the writer and editor of hundreds of online electronics repair guides. Kyle received a BS in Industrial Engineering from Cal Poly, San Luis Obispo.
    Kyle Smith
    wikiHow Technology Writer
    Expert Answer
    Using the formula =DAYS("1/10/2020","6/22/2019"), there are 202 days between 22 June 2019 and 10 Jan 2020.
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 2 Helpful 0
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
      Advertisement

      Tips

      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Submit
      Thanks for submitting a tip for review!

      You Might Also Like

      How to
      Recover a Corrupt Excel File
      How to Merge Cells in Microsoft Excel: A Quick Guide
      Easily Create a Drop-Down List in Microsoft Excel: Setup & Customization
      How to Use If‐Else in Microsoft Excel: Step-by-Step Tutorial
      How to
      Unprotect an Excel Sheet
      How to Create a Graph in Excel
      How to Fix Ethernet Doesn't Have a Valid IP Configuration on Windows
      How to
      Link Sheets in Excel
      How to
      Create a Mortgage Calculator With Microsoft Excel
      How to
      Make a Spreadsheet in Excel
      How to
      Insert Pictures in Excel That Automatically Size to Fit Cells
      How to Unhide Multiple Rows in Microsoft Excel
      How to Combine Columns in Excel Without Losing Data
      How to Create an Inventory List in Microsoft Excel: Step-by-Step Guide
      Advertisement

      References

      1. ↑ https://support.microsoft.com/en-us/office/calculate-the-difference-between-two-dates-8235e7c9-b430-44ca-9425-46100a162f38
      2. ↑ https://support.microsoft.com/en-us/office/days-function-57740535-d549-4395-8728-0f07bff0b9df

      About This Article

      Thanks to all authors for creating a page that has been read 156,742 times.

      Is this article up to date?

      Advertisement