A waiting period tracker is a table with one row per member and per waiting period, showing when each starts, when it ends and what it relates to. For a family, the parents will often have longer waits than the children, and different waiting periods will end on different dates. Writing them out lets you see, at a glance, which conditions are not yet covered, and avoids learning it for the first time in a hospital.
What kinds of waiting period are there?
Policies commonly mention an initial waiting period at the start, a waiting period for named illnesses or procedures, and one for conditions you already had when you bought the policy. The names, lengths and lists differ from insurer to insurer, so use the terms and numbers in your own policy wording and the schedule the insurer sent. If you moved from another policy, ask the insurer in writing whether and how earlier cover is counted, and file the reply.
A tracker filled in with made-up numbers
Say a family policy began on 1 April 2026. The father and mother are in their fifties and declared a pre-existing condition. The two children have none. The wording, as imagined here, gives a 30-day initial wait for everyone, 24 months for specific illnesses and 36 months for pre-existing conditions.
| Member | Waiting period | Start date | End date | Note |
|---|---|---|---|---|
| Father | Initial, 30 days | 1 April 2026 | 1 May 2026 | Applies to all members |
| Father | Specific illness, 24 months | 1 April 2026 | 1 April 2028 | Check the list in the wording |
| Father | Pre-existing, 36 months | 1 April 2026 | 1 April 2029 | Declared condition noted at purchase |
| Mother | Initial, 30 days | 1 April 2026 | 1 May 2026 | Applies to all members |
| Mother | Specific illness, 24 months | 1 April 2026 | 1 April 2028 | Check the list in the wording |
| Child one | Initial, 30 days | 1 April 2026 | 1 May 2026 | No pre-existing wait declared |
| Child two | Initial, 30 days | 1 April 2026 | 1 May 2026 | No pre-existing wait declared |
How do you work out the end dates in a sheet?
For waiting periods stated in days, put the start date in C2 and the number of days in a column, then use =C2+30 or point to the days cell. For periods stated in months or years, use EDATE, which works in Excel and Google Sheets: =EDATE(C2, 24) gives the date 24 months after the start, and =EDATE(C2, 36) gives 36 months. Format the result cells as dates. Always compare the answer with the date the insurer states, because the policy may count from a different date such as the date of cover starting after acceptance.
What should the note column say?
- The page or clause of the policy where the period is defined.
- The condition or list the period applies to.
- Whether it restarts if you port the policy or increase the sum insured, as your insurer states it.
- Who in the family it affects, since the same row can differ by member.
- The name and date of any written clarification from the insurer.
Where should this live?
Keep the tracker in the same folder as the policy schedule, and share the folder with a trusted family member, so someone else can read it if you are unavailable. Add a calendar alert a month before each end date. If you use SpendixAI for premiums, you can link each premium to a health insurance category, but the waiting period dates themselves are better in a table like the one above.
Review each year
- Has a waiting period ended since the last review?
- Did anyone join the policy, which means a new row?
- Did the insurer send revised terms at renewal?
- Is the sheet saved alongside the new schedule?
Useful ideas start with a clearer picture of your own spending.
Explore your reports

