Table of Contents
To calculate the number of weeks between two dates in Excel, subtract the start date from the end date, then divide the result by 7 to get the number of weeks. Make sure to format the result as a number so that you get the exact number of weeks instead of a date.
You can use the following formulas to calculate the number of weeks between two dates in Excel:
Formula 1: Calculate Full Weeks Between Two Dates
=INT((B2-A2)/7)
Formula 2: Calculate Fractional Weeks Between Two Dates
=(B2-A2)/7
Both formulas assume that cell A2 contains the start date and cell B2 contains the end date.
The following examples show how to use each formula in practice.
Example 1: Calculate Full Weeks Between Two Dates
The following screenshot shows how to calculate the number of full weeks between a list of start and end dates in Excel:
Here’s how to interpret the output:
- There are 4 full weeks between 1/1/2022 and 2/4/2022.
- There are 20 full weeks between 1/7/2022 and 5/29/2022.
- There are 2 full weeks between 1/20/2022 and 2/5/2022.
And so on.
Example 2: Calculate Fractional Weeks Between Two Dates
The following screenshot shows how to calculate the number of fractional weeks between a list of start and end dates in Excel:
Here’s how to interpret the output:
- There are 4.857 weeks between 1/1/2022 and 2/4/2022.
- There are 20.286 weeks between 1/7/2022 and 5/29/2022.
- There are 2.286 weeks between 1/20/2022 and 2/5/2022.
And so on.
Related: