Excel + Google Sheets · AI prompt
Ask AI, paste, done
Describe what you want in plain words and ask ChatGPT, Gemini or Copilot for the formula.
The formula
=IF(AND(B2<TODAY(), C2<>"Done"), "Late", "On time")What each part means
AND(...)Both conditions"Late"If true"On time"If not
Example
TODAY: NOV 10
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Task | Due | Status | Check |
| 2 | Invoice | Nov 3 | Pending | |
| 3 | Report | Nov 14 | Pending | |
| 4 | Supplier | Nov 7 | Done | |
| 5 | Call | Nov 8 | Pending |
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Task | Due | Status | Check |
| 2 | Invoice | Nov 3 | Pending | Late |
| 3 | Report | Nov 14 | Pending | On time |
| 4 | Supplier | Nov 7 | Done | On time |
| 5 | Call | Nov 8 | Pending | Late |
Step by step
- Open ChatGPT, Gemini or Copilot.
- Describe your columns and what you want, in your own words.
- Paste the formula it gives you in cell D2:
=IF(AND(B2<TODAY(), C2<>"Done"), "Late", "On time") - Press Enter and drag it down.
Where it works
- Every version of Excel
- Google Sheets
- Excel for the web (free)
The same formula in other languages
- English AI prompt
- Español Prompt de IA
- Português Prompt de IA