Number of Weeks Between Dates in Excel & Google Sheets

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on February 6, 2023
Download Example Workbook

Download the example workbook

This tutorial will demonstrate how to calculate the number of weeks between two dates in Excel and Google Sheets.

weeks between dates


Weeks Between Dates

To calculate the number of weeks between two dates, first calculate the number of days between the dates. We will do this by subtracting the dates:


Days BW

Next we will divide the number of days by 7 to calculate the number of weeks:



We can calculate the number of full weeks with the TRUNC or INT Functions:



Or you can use the ROUNDUP Function so that a partial week is counted as a full week:


WKs Round UP

Weeks Between Dates in Google Sheets

All of the above examples work exactly the same in Google Sheets as in Excel.

Weeks between days Google

AI Formula Generator

Try for Free

Excel Practice Worksheet

practice excel worksheet

Practice Excel functions and formulas with our 100% free practice worksheets!

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!

Free Download

Return to Excel Formulas List