Date formula page
Days Until Due Date Formula
Use this when a task, invoice, or project row has one due date and you want days remaining.
Calculate days until a due date.
If A2 is a future due date, the formula returns the remaining calendar days.
Copy formulas
=IF(A2="", "", A2-TODAY())=IF(A2="", "", A2-TODAY())Excel and Google Sheets use the same formula syntax for this pattern.
Example data
| Task | Owner | Status | Due Date | Hours |
|---|---|---|---|---|
| Import leads | Maya | Complete | 2026-01-06 | 3 |
| Clean headers | Nico | In Progress | 2026-01-08 | 2 |
| Review budget | Maya | Complete | 2026-01-12 | 4 |
| Publish report | Iris | Blocked | 2026-01-15 | 1 |
Formula explanation
- The blank guard keeps empty due dates from showing a number.
- A2 minus TODAY returns remaining days.
- Negative results mean the item is overdue.
What this formula does
Days Until Due Date Formula is built around IF. The example formula on this page is =IF(A2="", "", A2-TODAY()), and it is written against sample columns such as Task, Owner, Status, Due Date, Hours.
Excel and Google Sheets use the same copy pattern here, so the main work is adjusting ranges, criteria, and output cells to match your sheet.
Date formulas work because spreadsheet dates are stored as serial values. The visible date format can change, but the underlying value must still be a real date for the formula to be reliable.
Use this pattern for this task: Calculate days until a due date. If the result looks like a number, format the output cell as a date or number according to the result you expect.
| Syntax piece | Role in the formula |
|---|---|
| Part 1 | The blank guard keeps empty due dates from showing a number. |
| A2 | A2 minus TODAY returns remaining days. |
| Part 3 | Negative results mean the item is overdue. |
Practical use cases
=IF(A2="", "", A2-TODAY())Excel: Use this in a timeline, invoice, or task tracker where real date cells control the result. Returns: If A2 is a future due date, the formula returns the remaining calendar days.
=IF(A2="", "", A2-TODAY())Google Sheets: Use this when a report needs a repeatable date calculation that can be filled down row by row. Returns: If A2 is a future due date, the formula returns the remaining calendar days.
Common errors
- Cells that only look like dates may actually be text.
- Inclusive date counts require adding 1 when both start and end dates should count.
- Date formulas can return decimals when source cells contain times.
Common errors and troubleshooting
| Issue | Likely cause | Fix |
|---|---|---|
| Copied formula gives an unexpected result | Cells that only look like dates may actually be text. | Format source cells as dates, remove text dates, and decide whether endpoints should be inclusive or exclusive. |
| Common setup problem | Inclusive date counts require adding 1 when both start and end dates should count. | Format source cells as dates, remove text dates, and decide whether endpoints should be inclusive or exclusive. |
| Common setup problem | Date formulas can return decimals when source cells contain times. | Format source cells as dates, remove text dates, and decide whether endpoints should be inclusive or exclusive. |
| Result shows a serial number | The formula returned a valid date value, but the output cell is formatted as a number. | Change the output format to Date, or keep the number format when the expected answer is an elapsed day count. |
| Date calculation is off by one day | The business rule may count both endpoints, or the source cells may contain time values. | Add 1 only for inclusive elapsed days, and remove times or use explicit boundaries when comparing dates. |
When not to use this formula
- Do not use simple date subtraction for business days; use NETWORKDAYS or WORKDAY.
- Do not use DATEDIF for rounded month math; it returns completed periods.
Alternatives
| Alternative | When to use it |
|---|---|
| Date Difference Formula Builder | Use for days, completed months, or completed years. |
| Excel Date Serial Converter | Use when imported dates arrive as serial numbers. |
| FILTER Rows by Date | Use when the goal is returning rows by date instead of calculating one value. |
Compare with related formulas
| Formula or tool | How it differs | Use it instead when |
|---|---|---|
| Date Difference Formula Builder | Date Difference Formula Builder solves a nearby workflow, while Days Until Due Date Formula is focused on calculate days until a due date. | Use for days, completed months, or completed years. |
| Excel Date Serial Converter | Excel Date Serial Converter solves a nearby workflow, while Days Until Due Date Formula is focused on calculate days until a due date. | Use when imported dates arrive as serial numbers. |
| FILTER Rows by Date | FILTER Rows by Date solves a nearby workflow, while Days Until Due Date Formula is focused on calculate days until a due date. | Use when the goal is returning rows by date instead of calculating one value. |
Test cases
| Test | Platform | Formula | Returns |
|---|---|---|---|
| Excel copy output | Excel | =IF(A2="", "", A2-TODAY()) | If A2 is a future due date, the formula returns the remaining calendar days. |
| Google Sheets copy output | Google Sheets | =IF(A2="", "", A2-TODAY()) | If A2 is a future due date, the formula returns the remaining calendar days. |
Related formulas
FAQ
What does the Days Until Due Date Formula do?
It supports this task: Calculate days until a due date. The example uses A2, but you should replace the ranges and criteria with the cells in your own workbook.
Does the Days Until Due Date Formula work in Excel and Google Sheets?
Yes. The Excel and Google Sheets versions on this page use the same syntax for this pattern.
What should I change before copying the formula?
Change the source ranges, criteria cells, and output range references so they match your sheet. Keep related ranges on the same rows unless the formula notes say otherwise.
Why does my date formula show a number?
The result is probably a valid spreadsheet date serial. Format the output cell as Date when the answer should display as a date.
Does this count both the start and end date?
It depends on the formula. Functions like NETWORKDAYS count both the start and end dates by default, while a plain end-minus-start subtraction does not. Add 1 only when your rule should count both endpoints, and check the expected result section for this formula.
What if my date is stored as text?
Convert text dates to real spreadsheet dates before relying on date math. Text that only looks like a date can produce wrong results.