Google Sheets is a powerful tool for organizing and analyzing data. One common task that many users may need to perform is calculating the number of weeks between two dates. This number can be useful for tracking project timelines, measuring progress, and more. Fortunately, with a few simple formulas, you can easily find the number of weeks between two dates in Google Sheets.
Contents
Step 1: Enter the dates
The first step is to enter the two dates you want to compare into Google Sheets. For example, if you want to compare the dates in cells A1 and A2, you could enter them like this:
A  B 

Date1  Date2 
1/1/21  1/9/21 
Step 2: Calculate the number of days
To find the number of weeks between two dates, you must first calculate the number of days between them. You can do this using the simple subtraction formula =end_date  start_date
, where “end_date” and “start_date” are the cells containing the dates you want to compare. In the example above, you would enter the following formula in cell C2:
Formula: =B2A2
This formula will calculate the number of days between Date1
and Date2
, which is 8.
Step 3: Convert days to weeks
Once you have the number of days between the two dates, you can convert this to the number of weeks by dividing by 7 (since there are seven days in a week). You can use the division formula =days / 7
to do this. Using the data in the table above, you would enter the following formula in cell C2:
Formula: =(B2A2)/7
This calculation will give you the number of weeks between Date1
and Date2
, 1.1429. Since you’re most likely looking for full weeks, remove the decimal value and leave a whole number.
Step 4: Round the result to whole weeks
Finally, round down the result to the whole number rather than a decimal. You can use the INT function =INT(weeks)
to do this. In the example above, you would use the following formula.
Formula: =INT((B2A2)/7)
Live Example in Sheets
Feel free to use this Google Sheet with the examples from this article.
TIMEDIF AddOn – No Formulas
For a mixed output with years, weeks, or months, consider using the TIMEDIF addon. This addon creates an accurate result with no code.
Conclusion
In conclusion, calculating the number of weeks between two dates in Google Sheets is a straightforward process you can accomplish using simple formulas. Following the steps outlined above, you can quickly and easily determine how many weeks are between any two dates in your spreadsheet.
Related Tutorials

TRAVELDIRECTIONS Function – Google Sheets
Learn how to use the TRAVELDIRECTIONS function to write directions directly into Google Sheets.

TRAVELROUTEURL Function – Google Sheets
Learn how to use the TRAVELROUTEURL function in Google Sheets to create links to Google Maps directions.

TRAVELTIME Formula – Google Sheets
Learn how the TRAVELTIME formula calculates the trip duration between two locations.

Travel Formulas – Time and Distance Formulas in Google Sheets
Use the Travel Formulas addon to calculate time and distance in Google Sheets.

How to Calculate Age in Minutes Using Google Sheets
Learn how to calculate age in minutes using Google Sheets.

How to Calculate Age in Hours Using Google Sheets
Learn how to find the number of hours between two times in Google Sheets.