# Excel: Calculate the Number of Weeks Between Dates

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.