Table of Contents
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
=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.