Level 2DatesPractice, 2 min
Days between two dates
The task
How long did this deal take to close? In D2, work out the number of days from Created (B2) to Closed (C2).
The data
The starting sheet. Cells outlined in green are where your formulas go.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Deal | Created | Closed | Days to close |
| 2 | Northwind renewal | Mar 9, 2026 | Apr 21, 2026 | |
| 3 | Cobalt upsell | Apr 2, 2026 | May 14, 2026 |