How to Calculate the Number of Days between Two Dates in Microsoft Excel

Written by danielle cort
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Calculate the Number of Days between Two Dates in Microsoft Excel
Use subtraction to count the number of days between two dates. (Jupiterimages/Comstock/Getty Images)

Whether you need to prepare a list of due dates for a project or figure out how many days there are in a billing cycle, you can calculate it using Excel's basic functions. Although Excel offers a variety of date-related functions, it is not necessary to use them because Excel can add and subtract dates using standard arithmetical functions. In fact, Excel recognises date formats automatically, making it easy to manipulate dates like you would other numbers.

Skill level:
Moderately Easy

Other People Are Reading

Instructions

  1. 1

    Open the Excel workbook with dates you want to work with.

  2. 2

    Enter the first or starting date in an empty cell. For example, if you want to enter the first day of the billing cycle, you can enter that in cell A1. Make sure you enter the month, day and year. If you do not enter a year, Excel will default to the current year.

  3. 3

    Enter the second or ending date in another empty cell, for example, cell B1.

  4. 4

    Highlight both cells and click the number format window in the "Number" group on the ribbon. Select "Short Date" or "Long Date" from the menu, depending on how you want the dates displayed. The number format window typically displays the word "General" initially, but it can display "Custom" or any of the other formats. Excel generally recognises dates when they are entered in date format; however, it is always useful to make sure your cells are formatted as dates.

  5. 5

    Click an adjacent cell such as C1 to enter your formula. Type the following formula, substituting your own cell numbers for "B1" and "A1," and press "Enter":

    =B1-A1

    Excel will subtract one date from the other and display the number of days between the two dates.

Tips and warnings

  • To find the number of days between a target date and today, enter "=TODAY()" without quotes, instead of one of the dates in your table. Excel will calculate the number of days between the target date and today.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.