Formula help

Label past-due dates in Google Sheets.

Use this page when you need a clear Google Sheets formula for overdue dates, rolling windows, or simple due-date labels.

Formula helpGoogle SheetsFormula-only ready

How to use it

Start with the same request, then adjust it to your sheet.

Use this page when you need a clear Google Sheets formula for overdue dates, rolling windows, or simple due-date labels.

Step by step

  • Set the platform to Google Sheets.
  • Describe the due-date rule.
  • Review the resulting formula and example outputs.

Useful variations

  • Ask for a color/label style outcome in the formula text.
  • If you want a pure TRUE/FALSE result, say that directly.

Worked example

Example input and output

Due Date
2026-03-01
2026-04-25

Expected output

FormulaResult
=IF(A2<TODAY()-30,"Past due","Current")Past due
=IF(A3<TODAY()-30,"Past due","Current")Current

Try it now

Open the tool with this example already filled in.
Open this example

Related pages

Keep going from here.

Google Sheets Formula Generator from Plain English

Generate Google Sheets formulas from plain English and compare worked examples before pasting into your sheet.

Excel Date Formula Generator

Generate Excel date formulas from plain English for overdue checks, age calculations, and rolling windows.

Formula Generator from Text

Turn a plain-English spreadsheet task into a formula for Excel or Google Sheets.