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

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 recognizes date formats automatically, making it easy to manipulate dates like you would other numbers.

Use subtraction to count the number of days between two dates.

#### Step

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

#### Step

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.

#### Step

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

#### Step

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 recognizes dates when they are entered in date format; however, it is always useful to make sure your cells are formatted as dates.

#### Step

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

#### Step

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