On the Staff tab, add each person once: staff number, name, role (Nurse, Doctor, Clinical Officer, Lab, Support) and phone. On the Roster tab, pick a shift for each staff member across Monday to Sunday from the dropdown (Day, Night, Off, Leave). Each person's day, night, off and leave counts fill in automatically, and the coverage block under the grid counts how many are On Day and On Night each day. Set your Min Day and Min Night targets and any day below them is flagged GAP in red.
Log time off on the Leave Tracker, where the number of days works itself out from the start and end dates. The Summary tab reads the whole week back to you: staff on the roster, day and night shifts, leave days, and how many days have a coverage gap. Yellow cells are the only ones you type in; every other cell is a locked formula. Opens in Excel, WPS or Google Sheets.