How to calculate the number of weeks between two dates in Excel

Q: How do I show weeks and days, like "3 weeks, 4 days"?

=INT((C2-B2)/7)&" weeks, "&MOD(C2-B2,7)&" days".

Q: How do I count weeks from a date until today?

Put =TODAY() in a cell, say F1, and use it as the end date: =INT((F1-B2)/7).

Formula (Excel and Google Sheets)

=INT((C2-B2)/7)

Divide the days by 7 and drop the remainder: =INT((C2-B2)/7) returns the number of complete weeks.

Result on the example: one result per row in D2, filled down to D6
Works in: Every current version
Google Sheets: Same formula

See it work

The formula is already in D2, filled down to D6. Change any input and the result updates, or edit the formula to experiment.

How it works

Subtracting two dates gives the days between them, and dividing by 7 turns days into weeks. INT drops the leftover days, so only complete weeks count: Onboarding ran 25 days, which is 3 weeks and 4 days.

=INT((C2-B2)/7)

Result8

C23/2/2026
The value in C2.
B21/5/2026
The value in B2.
C2-B256
The - operator subtracts.
C2-B2)/78
The / operator divides.
INT((C2-B2)/7)8
INT: Rounds down to the nearest integer.
- numberC2-B2)/78

In Google Sheets

The same formula works in Google Sheets: =INT((C2-B2)/7). We ran it in Google Sheets mode on the same data and it returns the same results.

Other ways to do it

Each one was run on the same example sheet.

Formula	Result	When to use it
=(C2-B2)/7	8, 4, 6…Different result	Decimal weeks, like 3.57. Format the column with one or two decimals. Shows fractional weeks.
=ROUNDUP((C2-B2)/7,0)	8, 4, 6…Different result	Counts a part week as a full week, for billing by the week. Partial weeks round up.

Common mistakes

The result can pick up the date format and show as 1/8/1900. Format the column as a number.
ROUND instead of INT turns 3 weeks and 4 days into 4 weeks. Use INT for completed weeks.
If both the first and last day count, like a week-long event from Monday to Sunday, add 1 to the days first: =INT((C2-B2+1)/7).

Try it yourself

Same data, empty answer cell. Your formula is graded instantly, then re-checked on changed data, so a typed-in number won't pass.

Calculate the number of weeks between two dates

In D2, calculate how many complete weeks each project ran, and fill down to D6.

Questions

How do I show weeks and days, like "3 weeks, 4 days"?

=INT((C2-B2)/7)&" weeks, "&MOD(C2-B2,7)&" days".

How do I count weeks from a date until today?

Put =TODAY() in a cell, say F1, and use it as the end date: =INT((F1-B2)/7).

Checked by running on 2026-10-30: every formula and result on this page was calculated by the Spreadsheet Practice formula engine, in both Excel and Google Sheets modes.