# How to calculate the sprint number for a date in Excel

Divide the days since the first sprint by the sprint length: `=INT((A2-$E$1)/$E$2)+1`.

**Excel:** `=INT((A2-$E$1)/$E$2)+1` (Every current version)

**Google Sheets:** the same formula works.

## Example

Sample data (row 1 is the header):

| A | B | C | D | E |
| --- | --- | --- | --- | --- |
| Date | Sprint |  | Sprint 1 starts | 2026-01-05 |
| 2026-01-05 |  |  | Sprint length (days) | 14 |
| 2026-01-18 |  |  |  |  |
| 2026-01-19 |  |  |  |  |
| 2026-03-02 |  |  |  |  |
| 2026-06-30 |  |  |  |  |
| 2026-10-29 |  |  |  |  |

Formula in B2, filled to B7: `=INT((A2-$E$1)/$E$2)+1`

Result: 1; 1; 2; 5; 13; 22

## 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.

## Other ways

- `="Sprint "&(INT((A2-$E$1)/$E$2)+1)`: A label like Sprint 5. (Text label.)
- `=ROUNDDOWN((A2-$E$1)/$E$2,0)+1`: 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.

## 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`.

Every formula and result on this page was checked by running it in the Spreadsheet Practice formula engine on 2026-10-30.

Source: https://spreadsheetpractice.com/formulas/sprint-number-from-a-date