The Doctor On-Call Calendar in Excel is a macro-enabled workbook that turns a published on-call rota into something you can actually read: 7 sheets, 4 linked calendar views, and 100 worked sample duties already filled in across every month of 2026 – 02-Jan-2026 through 31-Dec-2026, spread over 8 hospital departments and 65 distinct duty types. Pick a month and the grid redraws. Pick a date range and the list rebuilds. No add-ins, no subscription, no account. It is a one-time $4.99 download (regular $8.99), it ships with a PDF user manual, and it is covered by the NextGenTemplates refund policy, so if it does not suit the way your department publishes its rota you are not stuck with it.
One thing to be clear about before you read any further, because it decides whether this is right for you: this workbook has no doctor-name column and no patient column. The Events sheet holds seven fields – ID, Date, Day, Event Name, Time, Location, Description – and nothing else. That is a deliberate design choice, and it is explained honestly further down.
Key Features of the Doctor On-Call Calendar in Excel
- Four linked views of one dataset – Annual View, Monthly View, Daily View and This Month all read the same Events sheet, so a duty typed once appears everywhere.
- Annual View on a single page – all twelve months of the chosen year in a 3 x 4 grid, with every date that carries a duty shaded, so a year of cover reads at a glance.
- Monthly View with a month and year picker – choose the month from a dropdown and the seven-column grid redraws with the duty names written into the day cells.
- Daily View with a start and end date filter – set any range (the sample ships at 02-Jan-26 to 01-Feb-26) and get a flat table of ID, Date, Day, Event Name, Time, Location and Description.
- This Month summary page – four count cards (Events This Month, Active Days, Locations Used, Next 7 Days), an Events by Day of Week breakdown, a Top 5 Locations table, and the full month list underneath.
- A VBA data-entry form – Add New Record, Update Record and Delete Record buttons open a six-field form where the day of the week fills itself in from the date you pick.
- Add New Event buttons on the calendar pages – both Monthly View and Daily View carry their own entry button, so you can add a duty without leaving the view you are looking at.
- 31 selectable years – the Setting sheet year list runs 2021 to 2051, so the same file carries you well past this rota cycle.
- 5 colour themes – Default, Blue, Red, Black and Orange; the file ships in Red, and the whole workbook re-skins from one dropdown.
- Week start and highlight controls – start the week on any day, start the calendar on any month, and highlight up to two days of the week plus every date that carries a duty.
- 100 realistic duties already typed in – night calls, second-on cover, weekend cover, handover rounds, locum cover, festival and public-holiday rotas, response drills and roster-publication deadlines.
- One file, no dependencies – a single .xlsm inside the download; nothing to install, nothing to connect, nothing to renew.
What Is Inside the Doctor On-Call Calendar in Excel
The download is a ZIP holding two files: the macro-enabled workbook and Excel Calendar – User Manual.pdf. The workbook itself has seven sheets.
1. Home
A plain navigation page: five buttons – Annual View, Monthly View, Daily View, This Month, Events. Every other sheet carries a home icon in its header to bring you back.
2. Annual View
The full year in a 3 x 4 grid, Jan-2026 to Dec-2026 in the shipped file. Dates that carry a duty are shaded, so in January 2026 you can see the eight covered dates – the 2nd, 5th, 8th, 12th, 17th, 21st, 26th and 29th – without scrolling anywhere. The year, the starting month, the first day of the week and the highlight colours all come from the Setting sheet.
3. Monthly View
A traditional Sun-to-Sat month grid with the duty name printed inside the day cell. January 2026 in the sample reads: On-Call Roster Published – January on the 2nd, Night Call Duty – Emergency Physician on the 5th, Morning Handover Round on the 8th, Winter Respiratory Surge Cover on the 12th, Weekend On-Call – Orthopaedic Surgeon on the 17th, Cardiology Second-On Call Duty on the 21st, Republic Day Holiday Cover on the 26th and Shift Swap Request Deadline on the 29th. Two buttons sit in the header: Add New Event and Show Events.
4. Daily View
The working list. Set a Start Date and an End Date and the table below rebuilds with every duty in that window, showing all seven Events fields. The refresh arrow re-runs the filter, and Add New Event opens the same entry form used elsewhere.
5. This Month
A one-screen month summary driven by its own Month and Year pickers. In the shipped August 2026 view the cards read Events This Month 8, Active Days 8, Locations Used 6 and Next 7 Days 2. Underneath, Events by Day of Week splits those eight duties (Saturday 3, Monday 2, Tuesday 1, Wednesday 1, Thursday 1, Sunday 0, Friday 0), a Top 5 Locations table ranks the busiest departments, and the eight duties for the month are listed in full below.
6. Events
The single source of truth: rows 5 to 104, IDs 1 to 100, seven columns. Add New Record, Update Record and Delete Record sit across the top. This is the only sheet you ever type into.
7. Setting
Year (2021-2051), starting month, week start day, two day-of-week highlights, a highlight-duties toggle, and the colour theme – Default, Blue, Red, Black or Orange.
The 100 sample duties
They are not filler. The 8 departments carry Medical Admin 29, Emergency Dept 16, General Medicine 12, ICU 10, Cardiology 9, Orthopaedics 8, Paediatrics 8 and Obstetrics 8. Start times run across 10 slots from 08:00 to 20:00. The 65 duty names cover the shapes a real rota takes – first and second on-call, night calls by specialty, weekend cover, labour-ward cover, locum cover, handover rounds, cardiac arrest and difficult airway drills, monsoon and heatwave surge cover, festival and public-holiday rotas, swap deadlines and monthly roster publication dates.
Doctor On-Call Calendar in Excel vs. Google Sheets vs. Paid Rota SaaS – Where This Fits
| This Excel calendar | Google Sheets equivalent | Paid rota / scheduling SaaS | |
|---|---|---|---|
| Cost | $4.99 once (reg. $8.99) | $4.99 once (reg. $8.99) | Per-clinician monthly subscription |
| Platform | Microsoft Excel for Windows, desktop | Any browser | Browser plus mobile app |
| Setup time | Minutes – open, enable macros, type | Minutes – make a copy | Weeks, usually with onboarding |
| Real-time team collaboration | No – one file, one editor at a time | Yes – simultaneous editing | Yes |
| Mobile access | Limited – macros do not run on Excel mobile | Yes | Yes |
| Customisable fields | Yes – it is your workbook | Yes | Only what the vendor exposes |
| Share with a link | No – you send the file | Yes | Yes |
| Year-1 cost, 5 users | $4.99 | $4.99 | Typically hundreds to thousands |
| Builds the rota for you | No | No | Yes – that is what you pay for |
| Swap requests and approvals | No – a deadline is just a dated entry | No | Yes |
| Works with no internet | Yes | No | No |
The honest summary: rota software generates and enforces a rota. This workbook displays one that has already been agreed. If you are a department of six to thirty clinicians whose rota is currently a Word table emailed round on the 25th of the month, this is the upgrade. If you are rostering four hundred clinicians against working-time rules, buy the software.
Who This Template Is For – and Who It Is Not For
A good fit if you
- Publish a monthly on-call rota for a single department or a small hospital and want it readable at a glance.
- Already work in Excel on a Windows desktop and do not want another login.
- Need the year, the month and the coming week visible from the same file.
- Want a printable month or year grid to pin on the noticeboard.
- Are a locum coordinator, rota administrator or clinical lead keeping track of who owes what cover.
Not a good fit if you
- Need names attached to duties inside the file. There is no doctor-name column. You can type a name into Event Name or Description, but you cannot filter or count by clinician.
- Need the rota built – fair rotation, leave balancing, working-time compliance. This does none of that.
- Need several people editing the same rota at once. Use the Google Sheets edition for that.
- Work on a Mac, an iPad or Excel for the web – the VBA forms and the view refreshes need Excel for Windows desktop.
- Want automatic reminders, SMS or email alerts. There are none.
How to Use the Doctor On-Call Calendar in Excel
- Unzip and open the .xlsm in Excel for Windows. Excel will show a yellow security bar – click Enable Content. The buttons, the entry form and the Daily View and This Month refreshes are all VBA, so without macros the file is a static picture.
- Set your year on the Setting sheet. Choose the year (2021-2051), the starting month, the first day of your week, and whether to highlight duty dates. Pick a colour theme while you are there.
- Clear the sample duties. On the Events sheet delete rows 5 to 104, or keep a couple as a pattern until you have the hang of the form.
- Type your published rota in. Use Add New Record on the Events sheet, or Add New Event from Monthly View or Daily View. Fill Date, Event Name, Time, Location and Description – Day fills itself in from the date.
- Read it back. Monthly View for the month on a page, Daily View for a date range, This Month for counts, Annual View for the whole year.
- Print or share. Every view has a print area already set. For a noticeboard, print Monthly View or Annual View; to circulate, send the file or a PDF of the month.
Real-World Use Cases
Meera, rota coordinator at a 180-bed district hospital
Meera publishes eight departmental rotas a month. She keeps one workbook per department, enters the agreed cover as soon as the consultants sign off, and prints the Monthly View for each department noticeboard. The On-Call Roster Published and Shift Swap Request Deadline entries in the sample are the two dates she actually cares about, and they are already modelled in the file.
Dr Alok, clinical lead in emergency medicine
Alok opens This Month on a Monday morning. Next 7 Days tells him how much cover is in the coming week; Events by Day of Week tells him whether the weekend is carrying too much of the load. When someone asks who is second-on this Saturday, he sets the Daily View range to that weekend and reads off the duty and the department, then takes the name from the departmental list he keeps separately.
Sana, practice manager at a five-consultant private clinic
Sana runs the whole clinic year from Annual View. She marks holiday cover, drill days and the two annual roster-publication dates, then works backwards. She has no IT department, no budget for scheduling software, and no interest in one – a $4.99 file that opens in the Excel she already has is exactly the size of the problem.
Honest Limitations – Read These Before You Buy
Every one of these was checked against the actual file, not the screenshots.
- No clinician name field. Seven columns, none of them a person. This keeps staff data out of a spreadsheet that gets emailed around – but it means the file tells you what cover exists, not who is providing it.
- Monthly View shows only one duty per date. The grid uses a lookup that returns the first match, and unlike some of our other calendars it prints no more-events counter. In the shipped sample all 100 duties fall on 100 different dates, so you will never see it – but if you enter two duties on one date, the month grid shows one of them. Daily View and This Month list both.
- No end time, so no hours. Time is a single start time. The workbook cannot total on-call hours, calculate rest between duties, or cost a rota.
- Nothing prevents a clash. Enter two duties in the same department at the same time and the workbook accepts both without a warning.
- The Top 5 Locations panel is a Top 5. It is labelled as such, but note that Locations Used can read higher than the number of rows shown – in the August 2026 sample it reads 6 against 5 listed departments.
- Windows desktop Excel only. Macros do not run in Excel for the web, Excel for iPad or Excel Mobile, and VBA UserForms are not supported on Excel for Mac.
Frequently Asked Questions
Is this a hospital management, EHR or practice-management system?
No. It is a Microsoft Excel calendar workbook. It stores no medical records, holds no patient data, connects to no clinical system, and is not an EHR, EMR, RIS, PACS or practice-management product. If you need one of those, buy one.
Does it store patient information?
No. There is no patient name, patient ID, hospital number, date of birth, diagnosis or clinical-notes field anywhere in the workbook, and none of the 100 sample duties contains a patient identifier. It records what cover is scheduled, where and when – nothing about the people being treated.
Is it HIPAA or GDPR compliant?
No. No spreadsheet is certified compliant on its own. The file has no encryption, no access control, no audit trail and no user accounts – anyone who can open it can change it. Compliance depends on how your organisation stores, shares and protects the file, and that is your responsibility, not the responsibility of the template.
Does it check safe-staffing rules or working-time regulations?
No. The workbook enforces no staffing ratio, no rest-break rule, no working-time regulation and no union or contractual agreement, and it makes no clinical or safety recommendation. It shows what you typed in.
Do I have to enable macros?
Yes. The Add New Record, Update Record and Delete Record buttons, the entry form, and the Daily View and This Month refreshes are all VBA. Click Enable Content when Excel prompts you, or use the Excel Trust Center to trust the folder you keep the file in.
Which Excel versions does it work in?
Microsoft Excel for Windows, desktop, 2010 or later, including Microsoft 365. It is not supported on Excel for Mac, Excel for the web, iPad or Android, because those cannot run the VBA UserForms.
Can I use it for a year other than 2026?
Yes. The Setting sheet year list runs from 2021 to 2051 – pick a year and all four views redraw. You can also start the calendar on any month, which suits departments running an April-to-March or July-to-June rota year.
Can more than one person edit it at the same time?
No – it is a desktop file. If simultaneous editing matters, the Doctor On-Call Calendar in Google Sheets is the same calendar built for the browser, at the same price.
Is there a refund if it does not fit?
Yes – the standard NextGenTemplates refund policy applies to this download.
Excel or Google Sheets?
This calendar exists on both platforms at the same price, and the choice is genuinely about how your department works. Take the Excel edition if the rota lives on one coordinator Windows PC, if you print it for a noticeboard, if you work offline, or if IT will not let a hospital rota leave the network. Take the Google Sheets edition if several people need to update the same rota, if consultants want it on their phones, or if you want to share a view-only link instead of emailing a file. Same four views, same 100-duty structure, different medium.
About the Author
Built by PK – Microsoft Certified Professional with 15+ years of Excel, Google Sheets, and Power BI experience. Founder of NextGenTemplates, reaching 300K+ subscribers across YouTube channels. Every template is hand-built and tested before release.
Explore Related Templates
The hospital scheduling range in Excel: Nurse Duty Roster Calendar in Excel for ward-level shift bands, Operation Theatre Booking Calendar in Excel for theatre lists, Radiology Slot Booking Calendar in Excel for scanner slots, and Patient Follow-Up Visit Calendar in Excel for review clinics. If you need the rota recorded per doctor rather than per duty, the Doctor Duty Roster Data Entry System in Excel is the sibling built for that. Browse the full Excel Calendar category, the Health and Safety category, or everything in MS Excel.
Get the Doctor On-Call Calendar in Excel for $4.99 (regular $8.99) – instant download, one file, no subscription. Enable macros, set your year, type your rota, print the month.
Last updated: 27 August 2026.
Reviews
There are no reviews yet.