Tracking Days-Open: The Vacancy Metric That Predicts Cost

The Invoice That Starts the Day a Position Goes Unfilled

A resignation lands on a Tuesday morning. By Wednesday the scheduling puzzle begins — shifts redistributed, overtime flagged, agency calls made. The formal job posting goes live sometime the following week, and the recruitment clock starts. What rarely starts at the same moment is a cost clock. Nobody opens a spreadsheet and writes: Day 1. One RN vacancy. Premium-coverage cost begins now.

That gap — between when a position opens and when anyone starts measuring what it's costing — is where vacancy expense quietly accumulates. By the time a travel nurse invoice arrives, the position has been open for weeks, the premium-coverage cost is already embedded in the period's labor spend, and the connection between that specific vacancy and that specific dollar amount has blurred.

Days-open tracking is the practice of recording, for every unfilled nursing position, the exact date it opened and monitoring the running count until a qualified hire starts. It sounds administratively simple. What it produces, paired with your budgeted FTE targets, is one of the clearest leading indicators of premium-labor spend you can put in front of a CFO or a board.

This article explains how days-open tracking works mechanically, why the 78-day average recruitment window makes the metric so consequential, and how to build the habit into your existing workflow — with or without purpose-built software.

Why 78 Days Is the Number to Hold in Mind

The 2026 NSI National Health Care Retention & RN Staffing Report (via Kahuna Workforce, 2026) puts the average time-to-fill for an experienced RN at 78 days. That is the Recruitment Difficulty Index figure — the median elapsed time from posting to a qualified candidate accepting an offer — drawn from NSI's dataset of 527 hospitals across 40 states.

Seventy-eight days is two and a half pay periods. It is ten or eleven scheduling cycles. For most facilities, it is long enough that agency or travel coverage stops feeling like a bridge and starts feeling like baseline.

The number matters for days-open tracking because it gives you a planning anchor. When a position opens, you are not budgeting for a two-week gap; you are, on average, budgeting for eleven weeks. A vacancy tracker that flags positions crossing 30 days, 45 days, and 60 days open gives leadership visible checkpoints before the 78-day average arrives — not after.

For facilities managing multiple simultaneous vacancies, the math compounds. Three open RN positions at 78 days each represent 234 position-days of premium-coverage exposure before any offer is accepted, let alone before a nurse clears orientation and takes independent assignment.

The Mechanics of Days-Open Tracking

Vacancy days open tracking requires four data points per position:

1. Position identifier — unit, role (RN, LPN, CNA), and shift (day/eve/nights).
2. Open date — the date the budgeted seat became vacant (resignation effective date, not the posting date; these are often different by days or weeks).
3. Status — actively posted, offer extended, pending orientation, filled.
4. Fill date — the date the replacement hire begins taking independent assignment (not the offer-acceptance date, not the first day of orientation, because the coverage gap continues through onboarding).

From those four fields you can derive:

• Days open to date — a running counter updated each week.
• Projected fill date — open date plus your facility's average time-to-fill (use the 78-day NSI benchmark as a starting point, then calibrate against your own historical data).
• Budgeted vs. actual FTE — the gap between your authorized headcount and your working headcount at any given moment. This is the figure that connects vacancy days to budget variance.

The budgeted vs. actual FTE comparison is worth dwelling on. A facility that budgets 42 RN FTEs on a med-surg floor and is running at 38.5 FTE-weighted headcount — because two positions have been open for six weeks and a third for three weeks — carries a 3.5 FTE gap. That gap is not abstract. It represents shifts that must be covered, either by overtime from the existing team, by agency staff, or by leaving acuity-adjusted coverage short. FTE-weighted headcount explained is worth reading alongside this piece for the mechanics of that calculation.

What Days-Open Makes Visible That Headcount Counts Miss

A weekly headcount snapshot tells you how many nurses are on payroll today. It does not tell you how long a gap has been open, which positions are aging toward the expensive end of the recruitment window, or how much premium coverage you have already consumed against a vacancy that has not yet closed.

Days-open tracking adds a time dimension to a static count. Three vacancies that opened yesterday look identical to three vacancies that have been open for 60 days on a headcount report. They do not look identical on a cost report.

Consider a worked example built on sourced benchmarks:

Worked example (model — apply your facility's own figures): A 200-bed community hospital carries three open RN positions, each at day 55 when the Director of Nursing reviews the vacancy log. Travel nurse coverage, per the NSI 2026 report (via Kahuna Workforce, 2026), can run as high as $160/hr. If even one of those three vacancies has been covered by a single travel nurse at a premium rate above your employed-staff cost, 55 days of coverage represents a substantial unbudgeted labor variance. Multiply across three positions and a unit with chronically elevated days-open, and the cost driver becomes legible in a way a headcount count never reveals.

This is why CFOs and Hospital Administrators increasingly want to see days-open alongside vacancy rate. The vacancy rate tells you the size of the gap; days-open tells you how long you have been paying to bridge it. The two figures together begin to answer the question that always follows a travel-nurse invoice: why did this happen, and what would it cost to prevent it?

For a deeper look at the staff-vs.-travel cost comparison, see travel nurse vs. staff cost.

Building the Tracking Habit: Four Practical Steps

You do not need a purpose-built platform to start days-open tracking. You need a consistent process.

Step 1: Define your open date consistently. The most common tracking error is using the posting date rather than the vacancy date. A position can sit unfilled for two weeks before HR opens the requisition. Those two weeks of premium coverage are real cost; they belong in the days-open count. Use the resignation effective date (or the date a position is vacated for any reason) as your start date.

Step 2: Separate position-days from headcount. Track each open position as its own row — do not aggregate vacancies into a single "three open positions" entry. A position opened 70 days ago and a position opened 5 days ago require different management responses. Aggregation obscures that urgency gradient.

Step 3: Flag aging positions explicitly. Set threshold markers at 30, 45, and 60 days. A position crossing 60 days open without an accepted offer is approaching the NSI 78-day average, meaning your remaining recruitment window is shorter than the window already elapsed. These positions deserve active escalation — expedited sourcing, pay-band review, or both.

Step 4: Connect vacancy days to budget variance weekly. A days-open log that lives in a separate spreadsheet from your labor budget is only half the picture. Bridging those two views — even manually in a shared workbook — turns days-open from a recruiting metric into a financial one. That is the shift that brings CFO and finance partners into the conversation before the invoice arrives, not after.

For a structured starting point, the Nursing Vacancy & FTE Forecasting Workbook provides a template built around exactly this workflow: position-level vacancy tracking, budgeted vs. actual FTE comparison by unit, and a days-open aging summary designed to sit alongside your existing labor-variance report.

From Tracking to Forecasting

Vacancy days open tracking is, by itself, a lagging-to-current metric. It tells you what is open and how long it has been open. The natural next step is forward projection: given your current open positions, your historical time-to-fill, and your anticipated attrition, what does your FTE gap look like 30, 60, and 90 days from now?

That is the domain of six-month vacancy forecasting. A days-open tracker is the data foundation that makes forecasting credible — you cannot project forward from historical vacancy patterns you have never recorded.

Facilities that sustain the days-open habit for two or three recruitment cycles accumulate enough position-level data to answer questions their peers cannot: Which units consistently take longer to fill? Which shifts generate the most premium-coverage cost per vacancy? Which roles are approaching the 78-day average before an offer is even extended? That pattern recognition is what separates reactive vacancy management from planned workforce investment.

The nursing workforce analytics guide covers the broader measurement framework this metric fits within.

The Cost Connection Is the Point

Vacancy days open tracking is not an HR administrative task dressed up as a financial metric. It is a financial metric that happens to live in HR data. Every day a nursing position stays open past the point where standard scheduling absorbs the gap, a premium-coverage cost accumulates — whether or not anyone is recording it.

The 2026 NSI report (via Becker's Hospital Review, 2026) places the average cost of a single RN departure at $60,090, a figure that includes recruitment, onboarding, and the premium-coverage costs incurred during the vacancy window. That departure cost is, in part, a days-open cost. Tracking position days gives you the visibility to intervene before the accumulation becomes a departure statistic.

A structured template is the lowest-friction starting point. The Nursing Vacancy & FTE Forecasting Workbook is available now — a practical, self-contained tool for nurse managers and Directors of Nursing who are ready to move the vacancy conversation from reactive to measured.