Vaccine Booster Due Dates

Excel Formulas › Veterinary & Pet Care

All versionsEDATE

Vaccines need boosters at set intervals — weeks for a puppy series, then years for adults. Adding the interval to the last dose date projects the next-due date and a reminder window.

Quick formula: next booster due date:
=EDATE(last_dose, interval_months)
Add the booster interval (in months) to the last dose date. Days until due flags upcoming reminders.

Functions used (tap for the full reference guide):

EDATEIF

The example

Last dose 2026-06-19, 12-mo booster.

AB
1ItemValue
2Last dose2026-06-19
3+12 months→ 2027-06-19

The formula

The formula:

=EDATE(last_dose_date, interval_months) // last dose + interval

How it works

How it works:

  1. EDATE adds the booster interval in months to the last dose date.
  2. For a puppy series in weeks, use last_dose + interval_weeks*7.
  3. Days until due = next_due − TODAY() — a live reminder countdown.
  4. Flag a reminder window (e.g. due within 30 days) with IF.

Educational use only — not veterinary or medical advice. Dosing, fluid rates, and protocols must be set and verified by a licensed veterinarian for the individual patient. Always double-check against the drug label and a current formulary.

Try it: interactive demo

Live demo

Last dose date and interval (months).

Due ·

Variations

Puppy series (weeks)

Short interval:

=last_dose + interval_weeks*7

Days until due

Reminder countdown:

=next_due - TODAY()

Due-soon flag

Within 30 days:

=IF(next_due-TODAY()<=30, "Due soon", "")

Pitfalls & errors

EDATE for months. It keeps the day-of-month across the interval.

Weeks vs months. Puppy series use weeks; adult boosters use months/years.

Not advice. Follow the label and your veterinarian’s protocol.

Practice workbook

📊
Download the free Vaccine Booster Due Dates practice workbook
A booster sheet with the puppy-series, days-until, and due-soon variants, plus 4 challenges with answers. No sign-up required.

Frequently asked questions

How do I calculate a vaccine booster due date in Excel?
Add the interval with EDATE: =EDATE(last_dose_date, interval_months). A 12-month booster after 2026-06-19 is due 2027-06-19.
How do I handle a puppy series in weeks?
Add weeks as days: =last_dose + interval_weeks*7.
How do I flag upcoming reminders?
=IF(next_due-TODAY()<=30, "Due soon", "").

Stop fighting formulas. Learn them in a day.

This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.

See the Formulas & Functions Class

Related formulas: Add months · Statute of limitations date · Days until a date

Function references: EDATEIF