This template was designed specifically for firefighters and EMS (Emergency Medical Services), who typically work a 24-hour on and 48-hour off schedule. The spreadsheet shows which days each of the 3 different shifts work, and allows you to list the names of personnel assigned to each shift or platoon.


Shift Calendar for Firefighters and EMS

for Excel
Shift Calendar
Screenshots: 1 2
⤓ Download
For: Excel 2010 or later & Excel for iPad/iPhone

Template Details

License: Private Use
(not for distribution or resale)

"No installation, no macros - just a simple spreadsheet" - by


This calendar was designed specifically for firefighter shift scheduling. The calendar automatically colors each day of the year based on the shift pattern and start date.

If an individual firefighter wants to create a calendar showing only the day he/she is working, a pattern such as "Bxx" or "xxA"can be used where "x" would indicate the days off and the "A" or "B" represents which shift he/she is working.

Update 5/22/2017: A "4 Shifts" worksheet has been added for creating a 4-shift rotation. See screenshot #2 above.