How to calculate the sprint number for a date in Excel
Formula (Excel and Google Sheets)
=INT((A2-$E$1)/$E$2)+1Divide the days since the first sprint by the sprint length: =INT((A2-$E$1)/$E$2)+1.
- Result on the example
- one result per row in
B2, filled down toB7 - Works in
- Every current version
- Google Sheets
- Same formula
See it work
The formula is already in B2, filled down to B7. Change any input and the result updates, or edit the formula to experiment.
How it works
A2-$E$1 is the days since sprint 1 began. Dividing by the sprint length and dropping the fraction with INT gives the number of complete sprints before the date, and +1 gives the sprint the date falls in: January 18 is day 13 of sprint 1, and January 19 starts sprint 2.
=INT((A2-$E$1)/$E$2)+1Result1
A21/5/2026The value in A2.
$E$11/5/2026The value in E1.
A2-$E$10The - operator subtracts.
$E$214The value in E2.
A2-$E$1)/$E$20The / operator divides.
INT((A2-$E$1)/$E$2)0INT: Rounds down to the nearest integer.- number
A2-$E$1)/$E$20
- number
INT((A2-$E$1)/$E$2)+11The + operator adds.
In Google Sheets
The same formula works in Google Sheets: =INT((A2-$E$1)/$E$2)+1. 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 |
|---|---|---|
| ="Sprint "&(INT((A2-$E$1)/$E$2)+1) | Sprint 1, Sprint 1, Sprint 2…Different result | A label like Sprint 5. Text label. |
| =ROUNDDOWN((A2-$E$1)/$E$2,0)+1 | 1, 1, 2…Different result | The same for dates from the first sprint on. ROUNDDOWN rounds toward zero, so dates before sprint 1 come out one higher than with INT. Differs only for dates before the first sprint. |
Common mistakes
- Dates before the first sprint give 0 or negative numbers. Guard them with
IF(A2<$E$1,"",…). - Lock E1 and E2 with $ so every row uses the same start and length.
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 sprint number for a date
B2, return the sprint number the date falls in, given the first sprint's start in E1 and the sprint length in E2. Fill down to B7.Questions
How do I get the start date of the sprint?
=$E$1+(B2-1)*$E$2.
How do I number weeks from a project start?
Use 7 as the length: =INT((A2-$E$1)/7)+1.
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.