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
