The caliper on final inspection reads clean, the parts ship. Three weeks later an internal check turns up the problem: the gauge's calibration had been overdue for over a month. Now it isn't one measurement in question — it's every part checked with that gauge since its last valid calibration. A missed date quietly turned into a potential recall.
If you manage measuring equipment — on the shop floor, in a lab, in QA — the core problem is familiar: every gauge has its own interval, its own next-due date, and it all lives in an Excel sheet nobody opens daily. That's what makes calibration dates more dangerous than most other deadlines.
=EDATE to compute the next due date, conditional formatting for the traffic light, a status column to filter on. What Excel can't do is remind you when the file is closed — and an overdue gauge doesn't just miss a date, it casts doubt on every measurement since the last valid cal.Here's the goal — a register where the "Next due" column colors itself:
Step 1: Build the calibration register
One row per gauge, with these columns: Gauge · ID · Last calibration · Interval (months) · Next due · Days · Status. That last "Next due" column is the one you'll color and watch — but you won't type it by hand.
Step 2: Auto-calculate the next due date
Let Excel do the math from the last calibration plus the interval:
=EDATE(C2, D2)
Here C2 is the last calibration date and D2 is the interval in months. EDATE adds the months cleanly and returns the next due date. Then a days-remaining helper:
=E2-TODAY()
Negative means overdue — and an overdue gauge belongs out of service until it's recalibrated.
Step 3: Color overdue and due-soon gauges
Select your "Next due" column (e.g. E2:E200), then Home → Conditional Formatting → New Rule → "Use a formula". Add two rules, overdue first:
Overdue (red fill): =AND($E2<>"",$E2<TODAY())
Due within 30 days (yellow fill): =AND($E2>=TODAY(),$E2<=TODAY()+30)
The locked reference $E2 applies the rule per row, and TODAY() recalculates every time you open the file, so the colors stay live. The same approach works for plain date reminders too — see how to set a date reminder in Excel.
The three methods compared
| Approach | Shows the due date | Actively reminds | Works when the file is closed |
|---|---|---|---|
| Conditional formatting | ✓ colors | — | No |
=EDATE + days column |
✓ date & number | — | No |
| Monitored deadline (CellAlert) | ✓ | ✓ email & calendar | Yes |
The limit every calibration spreadsheet hits
All of the above shares one weakness: it only works on a screen someone currently has open. Conditional formatting turns a cell red — in a file that's been closed on a drive for weeks. EDATE won't roll the next due date forward on its own after a recalibration. And a spreadsheet never pulls a gauge from service; it trusts that someone is looking. With calibration, "looking" is exactly what falls away under deadline pressure.
Keep Excel, add the reminder layer
You don't need a dedicated calibration-management system to be reminded reliably. Keep your register in Excel and turn the date cell into a monitored deadline. CellAlert is an Excel add-in: mark the "Next due" cell, set the lead time, interval and an owner, done. From then on it reminds you by email and calendar even when Excel is closed, rolls the next calibration forward automatically after you mark it done, and records who confirmed and when. It doesn't store your file — only the deadline plus a cell reference, with CSV export anytime. For the bigger picture across all your compliance dates, see compliance calendar software and why a matrix beats a flat list.
Frequently asked questions
How do I track calibration dates in Excel?
Build a register with one row per gauge: last calibration, interval, and a next-due date computed with =EDATE(last, interval). Add a =E2-TODAY() days column and conditional formatting for the traffic light. That shows the status — but Excel alone can't actively remind you.
How do I auto-calculate the next calibration due date?
Use =EDATE(C2, D2), where C2 is the last calibration date and D2 is the interval in months. EDATE adds the months and returns the next due date, which you can then color and monitor.
Can Excel remind me before a gauge is due?
Not on its own. Conditional formatting only colors a cell on a screen someone has open, and VBA macros only run while Excel is open. A reliable reminder when the file is closed needs a service that monitors the date outside Excel.
What happens if I run a gauge that's out of calibration?
Measurements taken with it during the overdue window count as unverified, so you may have to assess or re-check the affected parts. That's why an overdue gauge should be pulled from service immediately and the reminder should fire before the due date, not after.
Do I lose my spreadsheet if I use CellAlert?
No. CellAlert doesn't replace Excel and needs no migration. It stores only the deadline metadata plus a cell reference — not the file itself — with CSV export anytime. Your register stays the source of truth.
A calibration date doesn't forgive a glance too late — it drags the past in with it. CellAlert turns the date cell in your Excel register into a monitored deadline — reminded in time, rolled forward automatically, documented for the audit.