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.
Open the Excel workbook with dates you want to work with.
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.
Enter the second or ending date in another empty cell, for example, cell B1.
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.
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-A1Excel will subtract one date from the other and display the number of days between the two dates.
Tips & 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.