A medicine refill calendar needs three dates for each medicine: when you bought it, how many days it lasts, and the date it runs out. Put a reminder a week before the run-out date, and add the monthly bill beside it, so a parent never runs short and you always know the cost.
How do you work out when a medicine runs out?
Take the purchase date and add the number of days the supply lasts. If your father's tablet was bought on 3 March and the strip lasts 30 days, it runs out on 2 April. A reminder seven days earlier falls on 26 March. Check the dose on the prescription or with the doctor, because the days a strip lasts depend on how it is taken, and never stretch doses to save money.
| Parent | Medicine | Bought on | Days it lasts | Runs out on | Remind on |
|---|---|---|---|---|---|
| Father | Medicine A | 3 March | 30 | 2 April | 26 March |
| Father | Medicine B | 3 March | 30 | 2 April | 26 March |
| Mother | Medicine C | 10 March | 28 | 7 April | 31 March |
The dates are an example. 10 March plus 28 days is 7 April, and a week before that is 31 March.
Which formulas do the dates for you?
Put the purchase date in column C and the days it lasts in D, from row 2, and the following formulas work in Excel and Google Sheets.
- Run-out date in E2: =C2+D2
- Reminder date in F2: =E2-7
- Days left in G2: =E2-TODAY()
- Flag in H2: =IF(E2-TODAY()<=7,"Order now","")
- Monthly bill for a parent: =SUMIFS($I$2:$I$200,$A$2:$A$200,"Father") where column I holds the amount paid
Format the date columns as dates, or the sums will look like strange numbers. Sort by days left, so the medicine that runs out first is at the top.
What is the monthly medicine budget?
Add the cost of every medicine bought in the month. Say Father's medicines cost ₹2,400 a month and Mother's ₹1,850. The monthly total is ₹4,250, and a year is ₹51,000. Prices can change, so update the figure when a medicine or brand changes, and note why. If a doctor suggests a change of brand or dose, write the date and reason in a notes column.
Keep the sheet to one line per medicine, not one line per purchase, and overwrite the purchase date each refill, but copy the old row into a history tab first. That way the live sheet stays short and readable on a phone, while the history tab holds every price paid, which is useful if you ever need to explain a rise in the monthly bill or compare pharmacies on cost.
How do you get reminders that actually work?
- Create a repeating event in your phone calendar for the reminder date, with the medicine name and the pharmacy's number.
- Ask the pharmacy whether it keeps a list of regular medicines for your parent and can call you before the refill.
- Keep one spare week of the most critical medicine whenever you can, as agreed with the doctor.
- Name a backup person who can order, in case you are travelling.
Where an expense tracker fits
A sheet suits the calendar. For the money side, SpendixAI can import a bank or card statement, let you review the rows before saving, and use a category with a sub-category for each parent, so a report shows the monthly medicine spend. It sends notifications and a weekly summary, but it is not a medicine reminder, so keep the refill alerts in your calendar.
What to do this week
- List every regular medicine with the days it lasts.
- Enter the date of the last purchase for each.
- Set a calendar reminder a week before each run-out date.
- Save the pharmacy's phone number in your phone.
- Check the sheet again each month on the day you order.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

