You can use the following formulas to calculate the number of weeks between two dates in Google Sheets:

**Formula 1: Calculate Full Weeks Between Two Dates**

**=INT((B2-A2)/7)
**

**Formula 2: Calculate Full Weeks and Days Between Two Dates**

**=INT((B2-A2)/7)& " weeks, " & MOD((B2-A2), 7) & " days"
**

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 with the following columns of start and end dates in Google Sheets:

**Example 1: Calculate Full Weeks Between Two Dates**

We can type the following formula into cell **C2** to calculate the number of full weeks between the start date in cell **A2** and the end date in cell **B2**:

**=INT((B2-A2)/7)**

We can then click and drag this formula down to each remaining cell in column C:

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 Full Weeks and Days Between Two Dates**

We can type the following formula into cell **C2** to calculate the number of full weeks and days between the start date in cell **A2** and the end date in cell **B2**:

**=INT((B2-A2)/7)& " weeks, " & MOD((B2-A2), 7) & " days"
**

We can then click and drag this formula down to each remaining cell in column C:

Here’s how to interpret the output:

- There are
**4 weeks and 6 days**between 1/1/2022 and 2/4/2022. - There are
**20 weeks and 2 days**between 1/7/2022 and 5/29/2022. - There are
**2 weeks and 2 days**between 1/20/2022 and 2/5/2022.

And so on.

**Additional Resources**

The following tutorials explain how to perform other common tasks in Google Sheets:

How to Add & Subtract Weeks to Date in Google Sheets

How to Get First Day of Week in Google Sheets

How to Group Data by Week in Google Sheets