How to use it
Start with the same request, then adjust it to your sheet.
Use this page for date arithmetic, overdue rules, age calculations, and date comparisons in Excel.
Step by step
- Describe the date rule in plain English.
- Generate the Excel formula.
- Check the worked example before copying the formula into your workbook.
Useful variations
- Ask for age from date of birth, due-date labels, or rolling date windows.
- Mention whether you want a label, a boolean result, or a day count.