How to Calculate Weeks with Functions in Excel

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.
Determine weeks between dates in Excel.

Microsoft Excel does not have a specific function to calculate weeks between days. However, you can calculate this value by using the "INT" function and then dividing the result by seven. The "INT" function rounds whatever number you have. So, if you find the number of days between two dates and then divide by seven, the result is a number that is a decimal. By using the "INT" function, Excel rounds this amount to determine exactly how many weeks you have.

Advertisement

Step 1

Type your first date in cell A1.

Video of the Day

Step 2

Type your second date in cell A2.

Step 3

Type "=INT((A2-A1)/7)" in cell A3 to calculate the number of weeks.

Advertisement

Video of the Day

Advertisement

Advertisement

references