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