Excel stores dates as numbers, which makes week calculations easy once you know the two functions that do the work: INT for the full weeks and MOD for the leftover days. This guide builds the formula step by step with a real example, then covers the decimal version, the workday version, and the three errors that produce the classic wrong answers - a result formatted as a date, a week count that is one too high, and a negative span that behaves oddly.
Step 1: get the day count
Put the start date in cell A1 and the end date in B1. In C1, enter =B1-A1. Excel subtracts the two date serials and returns the elapsed days. Using January 5, 2026 in A1 and March 20, 2026 in B1, C1 returns 74. If C1 shows a date in January 1900 instead of a number, Excel has formatted the result as a date - select the cell, press Ctrl+1, and choose General. Nothing about the formula is wrong; only the display is.
Step 2: full weeks with INT, leftover days with MOD
In D1, enter =INT((B1-A1)/7). The division gives 10.5714, and INT discards the fraction, returning 10 - the full weeks. INT is the crucial choice: it always rounds down, which is exactly what "full weeks" means. In E1, enter =MOD(B1-A1,7) for the leftover days. MOD returns the remainder of the day count divided by 7, which here is 4. Your answer reads 10 weeks and 4 days, and you can label it in one cell with =INT((B1-A1)/7)&" weeks and "&MOD(B1-A1,7)&" days".
Prefer a single decimal figure for billing or timesheets? Use =ROUND((B1-A1)/7,2), which returns 10.57. Keep the day count column in the sheet as well - the decimal is a summary, and the exact days are what you check disputes against. The same pair of formulas drives our weeks between dates calculator, which is handy for spot-checking a spreadsheet row or two.

Working weeks: NETWORKDAYS and the divide-by-5 trap
If you need working time rather than calendar time, =NETWORKDAYS(A1,B1) counts Monday-to-Friday days, and a third argument lets you pass a range of holiday dates to remove those too. Two cautions. First, NETWORKDAYS counts both the start and end dates if they are workdays, so its result is one higher than the elapsed-workday count most people expect - subtract 1 if you need elapsed working days, and be consistent across the whole sheet. Second, dividing NETWORKDAYS by 5 gives full workweeks only if the span starts on a Monday; a span starting midweek produces a workday count whose "weeks" do not align with calendar weeks. For payroll questions, that distinction matters, and our guide on workweeks vs calendar weeks explains it fully.
WEEKNUM is not a week counter
Excel also offers =WEEKNUM(date) and =ISOWEEKNUM(date), and people regularly subtract two WEEKNUM results to get "weeks between". Do not. WEEKNUM returns the week of the year a date falls in, under a system where week 1 starts on January 1 and weeks begin on Sunday; ISOWEEKNUM returns the ISO week number, where weeks begin on Monday. Subtracting week-of-year numbers breaks across year boundaries and miscounts partial weeks at both ends. Use them for labeling which week a date belongs to - never for measuring the gap between two dates. If the raw day count itself is the problem, our days between calculator will confirm it in seconds before you rebuild a formula.
Building a reusable week-count table
Most people need this calculation more than once, so lay the sheet out as a table you can extend. Use column A for the start date, B for the end date, C for days with =B2-A2, D for full weeks with =INT(C2/7), E for leftover days with =MOD(C2,7), and F for a readable label with =D2&" weeks, "&E2&" days". Fill the formulas down and every new pair of dates is answered as you type it. Two refinements make the table trustworthy. First, add a guard in column C - =IF(OR(A2="",B2=""),"",B2-A2) - so empty rows stay blank instead of showing misleading numbers counted from Excel's day zero in January 1900. Second, if you prefer a single function for the weeks column, =QUOTIENT(C2,7) does the same job as INT for positive spans, since QUOTIENT discards the remainder by design. Keep INT if any span could be negative, because the two functions treat negative numbers differently, and a table that mixes them will confuse whoever inherits the file. Finally, freeze the header row and add filters: with a few hundred rows, the ability to sort by the weeks column turns the table from a calculator into a small reporting tool. One last habit protects all of this work: keep an untouched copy of the raw start and end dates on a backup sheet. Formulas can be rebuilt in minutes if a file is damaged, but re-typed dates introduce precisely the errors this guide exists to prevent, and they do it silently.
Three errors that break the formula
Rounding instead of truncating. ROUND((B1-A1)/7,0) turns 10.57 into 11. Full weeks are a floor, not a nearest value - use INT. Hidden times. A date pasted from another system may carry a time, making B1-A1 equal 73.5 instead of 74, and INT then reports 10 weeks with a misleading remainder. Wrap inputs as INT(A1) and INT(B1) to strip times. Reversed dates. If the end date is earlier, the subtraction goes negative and INT and MOD treat negatives in ways that surprise (MOD of a negative returns a positive remainder in Excel). Guard with =ABS(B1-A1) if order should not matter, or sort the dates first.
Aging a list: weeks since a start date, updated daily
One of the most useful versions of this formula measures from a fixed start date to today, so a list ages itself. For a start date in A2, =INT((TODAY()-A2)/7) returns the completed weeks since that date, and pairing it with =MOD(TODAY()-A2,7) gives the days into the current week. Project trackers use this for "weeks open" on tasks and tickets; HR sheets use it for weeks of service; landlords use it for weeks a property has been listed. Two habits keep such a sheet honest. First, remember TODAY() recalculates whenever the file opens, so a screenshot or printed copy is a snapshot - note the date on it. Second, guard future start dates: if a row's start date is next week, the formula returns a negative week count that looks like an error in a report. Wrap it as =MAX(0,INT((TODAY()-A2)/7)) if negative values should display as zero, or leave the negative showing if spotting bad data matters more than tidy output.
Frequently asked questions
What is the Excel formula for full weeks between two dates?
=INT((B1-A1)/7), where A1 is the start date and B1 is the end date. INT rounds the division down, giving the complete weeks. Add =MOD(B1-A1,7) in the next column for the leftover days.
Why does my week formula return a date instead of a number?
Excel has guessed the cell format. When a formula result involves dates, Excel often formats the answer as a date. Select the cell, open Format Cells, and set it to General or Number.
Can DATEDIF give me weeks between dates?
Not directly. DATEDIF supports years, months and days units, but no week unit. Use INT((end-start)/7) for full weeks, or DATEDIF with the "d" unit to get total days and divide that.
How do I count only working weeks or workdays in Excel?
For workdays use NETWORKDAYS(A1,B1), which removes Saturdays and Sundays, and optionally a holiday list. Dividing the result by 5 gives full workweeks. WEEKNUM and ISOWEEKNUM answer a different question - which week of the year a date falls in.
Why is my result one week too high?
Usually because the formula rounds instead of truncating, or because one date includes a time. ROUND((B1-A1)/7,0) rounds 10.57 up to 11; INT gives the correct 10 full weeks. Check for hidden times with =A1-INT(A1), which should be zero.
