Excel for Nurses: Rosters, Logs and Patient Counts

Excel for nurses usually means admin work around the care, not the care itself: who is on which shift, whose training is due, and how many patients are on the ward. A few functions handle all three: COUNTIF and COUNTIFS for counts, and EDATE and DATEDIF for dates. This guide builds a small example of each, so you can set up a roster, a training log or a patient count sheet, or get ready for a nursing role that asks for Excel skills.

Excel doesn't replace your hospital's clinical or rostering systems. Use it where your team already does, and follow local policy on what data a spreadsheet may hold.

What nurses use Excel for#

Most nursing spreadsheets fall into a few groups:

• Shift rosters: who works each day and shift, and whether every shift has enough staff.
• Training and certificate logs: completion dates, expiry dates and who is due soon.
• Patient counts: admissions, discharges and patients on the ward by date or ward.
• Checklists and stock lists: equipment checks and supply orders.

They all work best with the same layout: one row per record and one column per detail, with a single header row. A record is one thing you want to count, such as one shift, one course or one admission. Avoid merged cells and blank rows in the middle; they break sorting and formulas.

How to build a shift roster in Excel#

For counting, a long list beats a grid. Put each shift on its own row:

Add a drop-down list to the Shift column (Data > Data Validation > List, with the source Day,Night) so everyone types the same words. If your team prefers a grid with names down the side and dates across the top, the guide to making a weekly shift schedule shows that layout with dates that fill themselves.

Count staff on each shift with COUNTIFS#

COUNTIFS counts the rows that meet every condition you give it. To count the nurses on nights on 9 November:

=COUNTIFS(A2:A8,DATE(2026,11,9),C2:C8,"Night")

The result is 2 (Ben and Chloe). Each pair is a range and what it must match. DATE(2026,11,9) is the date written as a formula, so it works whatever your regional date format is.

Build a cover table with dates down the side and Day and Night across the top. Put the date in the row label and the shift in the column header, and point the formula at them:

=COUNTIFS($A$2:$A$8,$E3,$C$2:$C$8,F$2)

Fill it across and down. The $ signs keep the roster ranges fixed while the date and shift references move. To count shifts per nurse, one condition is enough: =COUNTIF(B2:B8,"Ana") returns 2. The COUNTIF function reference and the COUNTIFS function reference list the criteria you can use.

Track training and certificate expiry dates#

A training log needs the date each course was done and how long it stays valid. Excel works out the rest.

EDATE adds whole months to a date, so E2 shows 15 Mar 2026 and E3 shows 2 Sep 2026. Format column E as a date if you see a number. Use the validity periods your organization sets; the ones here are only examples.

Useful extra columns:

• Days left: =E2-TODAY(). A negative number means the certificate has expired.
• Months since completed: =DATEDIF(C2,TODAY(),"m"). On 9 November 2026, Ana's row gives 31.
• Due in the next 30 days: =COUNTIFS(E2:E50,">="&TODAY(),E2:E50,"<="&TODAY()+30).

DATEDIF counts complete months or years between two dates; the DATEDIF function reference lists its units. The same formula gives years of service, as the guide to calculating age and tenure shows. Add conditional formatting to colour rows that are due soon.

Count patients by ward and date#

For patient counts, keep one row per admission, with an ID instead of a name:

The "" criteria counts empty cells, so the third formula finds patients with no discharge date yet. If your dates include times, compare with a range instead, such as ">="&DATE(2026,11,4) and "<"&DATE(2026,11,5). The guide to counting days between dates covers length of stay and DATEDIF in more detail, and the COUNTIF guide shows every type of criteria.

Keep patient information safe#

Patient data is sensitive, so the spreadsheet rules matter as much as the formulas:

• Check your employer's policy before putting any patient details in a spreadsheet. Many organizations require approved systems instead.
• Use patient or record IDs, not names, wherever you can.
• Save files only in the locations your organization approves, and don't email them unless policy allows it.
• Sheet protection stops accidental edits. It is not a security control for sensitive data.

Excel skills for nursing jobs and interviews#

Roles such as nurse manager, ward coordinator, research nurse or nursing informatics often expect everyday Excel: tidy tables, sorting and filtering, COUNTIF and COUNTIFS, date formulas and a simple chart. The guide to Excel skills for healthcare admin covers readmission rates and average stay, which come up in hospital admin tests.

Not sure where you stand? The Excel level test takes a few minutes and shows which skills to work on. The basic Excel test is a good timed warm-up.

Practise it#

The fastest way to get comfortable is to work through a real-looking ward sheet. Practise the hospital admissions case study: length of stay, average stay and readmission rate, each checked instantly. For the building blocks, practise COUNTIF in a live spreadsheet and practise days between dates.