How to Calculate a Date Range

At one time or another, we all have needed to figure the number of days, weeks, or months between two particular dates. If you've used your finger and counted, "one, two, three..." across the squares of a calendar, you may have thought that there has to be a better way to work out the answer. There is, and these steps will explain how to utilize Microsoft Excel in order to calculate this date range.

Things You'll Need

• Microsoft Excel

Instructions

1. Open Microsoft Excel and then start a new workbook.

2. Enter the beginning date of the range for which you want to calculate in column A, row 1.

3. Enter the ending date of the range for which you want to calculate in column B, row 1.

4. Calculate the difference in days by going to cell C1 and typing in the following:
   =DATEDIF(A1,B1,"d")

5. Calculate the difference in weeks by going to cell C2 and typing in the following:
   =INT((B1-A1)/7)

6. Calculate the difference in months by going to cell C3 and typing in the following:
   =DATEDIF(A1,B1,"m")

7. You are finished! The values in days, weeks, and months of the calculated date range will be displayed in cells C1, C2, and C3 respectively.

Tips & Warnings

• Use the time and date function button under the "Formulas" tab in Microsoft Excel 2007 in order to quickly convert dates to their numerical format.

References

• Calculating Number of Days, Weeks, Months and Years between Dates

Resources

• Online Date Calculator