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: How to Calculate the Number of Months Between Dates in Excel
Additional Resources
The following tutorials explain how to perform other common operations in Excel:
How to Add & Subtract Weeks to Date in Excel
How to Group Data by Week in Excel
How to Sum by Week in Excel