A schedule that counts working days and a contract that counts calendar days drift apart over the holidays. In the example below, 60 working days that start Monday, November 23, 2026, finish on Friday, February 12, 2027, when the schedule calendar skips only weekends. Load the five federal holidays the Office of Personnel Management (OPM) lists for that window and the finish moves to February 19. Add a year-end shutdown and it moves to Monday, March 1, 99 calendar days after the start.

Calendar days and working days

FAR 52.211-10, the federal clause for fixed-price construction contracts, sets contract time in calendar days. The contracting officer fills in either a number of days after the contractor receives the notice to proceed or a calendar date, and the clause says that time includes final cleanup.

Many state highway contracts count working days instead. Iowa DOT’s standard specifications, revised October 20, 2026, define a working day as any calendar day other than a Saturday, Sunday or recognized legal holiday on which conditions outside the contractor’s control allow at least three-quarters of a normal day’s work on a controlling item. Iowa charges a half day when conditions allow at least half but less than three-quarters of a day, and nothing below half.

Iowa also has a winter rule. Section 1108 defines winter work as work at the site between November 15 and April 1. Unless the proposal form requires winter work, a project started before November 15 that still has working days left on that date can work through the winter with no days charged.

The schedule calendar in P6, Microsoft Project or a spreadsheet is a third count. It holds the days the crews plan to work. When it skips fewer days than the field actually takes off, the forecast finish comes out early by the difference.

Which holidays to load

OPM publishes the holidays set by 5 U.S.C. 6103 for federal employees. Between Thanksgiving 2026 and the end of February 2027 it lists five that fall on weekdays. Iowa DOT observes nine holidays a year. Its list adds the Friday after Thanksgiving and leaves out Washington’s Birthday, Juneteenth and Columbus Day.

Weekday holidays from November 23, 2026, through March 1, 2027, on the OPM federal list and the Iowa DOT list.
DateDayHolidayOPM federal listIowa DOT list
2026-11-26ThursdayThanksgiving DayYesYes
2026-11-27FridayFriday after ThanksgivingNoYes
2026-12-25FridayChristmas DayYesYes
2027-01-01FridayNew Year's DayYesYes
2027-01-18MondayBirthday of Martin Luther King, Jr.YesYes
2027-02-15MondayWashington's BirthdayYesNo
Source: opm.gov

For most federal employees, OPM observes a Saturday holiday on the Friday before and a Sunday holiday on the Monday after. Christmas 2027 falls on a Saturday, so OPM’s 2027 list shows Friday, December 24. Iowa’s specification lists the holidays by date and rule, such as “Christmas Day, December 25.” When a contract names no holiday list, settle which one applies with the owner before the first schedule submission.

Worked example

The figures below are an example. A general contractor has 60 working days of interior work left on a building, starting Monday, November 23, 2026, on a five-day week. The scheduler builds three calendars:

  1. Weekends only.
  2. Weekends and the five OPM federal holidays in the window.
  3. The federal holidays, plus the Friday after Thanksgiving and a company shutdown from Thursday, December 24, through Friday, January 1.

With a year-end shutdown, 60 working days stretch to March 1

Cumulative working days from Monday, November 23, 2026, by week ending. Five-day week.

With a year-end shutdown, 60 working days stretch to March 1Line chart with 15 points from November 2026 to March 2027. Series: Weekends only, Federal holidays, Federal holidays and shutdown. Values range from 0 to 75.0204060802026-112026-122027-012027-012027-022027-03November 2026: 5December 2026: 10December 2026: 15December 2026: 20December 2026: 25January 2027: 30January 2027: 35January 2027: 40January 2027: 45January 2027: 50February 2027: 55February 2027: 60February 2027: 65February 2027: 70March 2027: 75Weekends onlyNovember 2026: 4December 2026: 9December 2026: 14December 2026: 19December 2026: 23January 2027: 27January 2027: 32January 2027: 37January 2027: 41January 2027: 46February 2027: 51February 2027: 56February 2027: 60February 2027: 65March 2027: 70Federal holidaysNovember 2026: 3December 2026: 8December 2026: 13December 2026: 18December 2026: 21January 2027: 21January 2027: 26January 2027: 31January 2027: 35January 2027: 40February 2027: 45February 2027: 50February 2027: 54February 2027: 59March 2027: 6464Federal holidays and shutdown
With a year-end shutdown, 60 working days stretch to March 1Line chart with 15 points from November 2026 to March 2027. Series: Weekends only, Federal holidays, Federal holidays and shutdown. Values range from 0 to 75.0501002026-112027-012027-03November 2026: 5December 2026: 10December 2026: 15December 2026: 20December 2026: 25January 2027: 30January 2027: 35January 2027: 40January 2027: 45January 2027: 50February 2027: 55February 2027: 60February 2027: 65February 2027: 70March 2027: 75Weekends onlyNovember 2026: 4December 2026: 9December 2026: 14December 2026: 19December 2026: 23January 2027: 27January 2027: 32January 2027: 37January 2027: 41January 2027: 46February 2027: 51February 2027: 56February 2027: 60February 2027: 65March 2027: 70Federal holidaysNovember 2026: 3December 2026: 8December 2026: 13December 2026: 18December 2026: 21January 2027: 21January 2027: 26January 2027: 31January 2027: 35January 2027: 40February 2027: 45February 2027: 50February 2027: 54February 2027: 59March 2027: 6464Federal holidays and shutdown
Worked example, not reported data. Holiday dates from OPM.
Example. Finish date for 60 working days starting Monday, November 23, 2026, under three calendars. Calendar days count the start day as day 1.
CalendarWeekday holidays and shutdown days before finishFinish dateCalendar daysCalendar days per working day
Weekends only02027-02-12821.37
Weekends and OPM federal holidays52027-02-19891.48
Federal holidays plus Nov. 27 and a Dec. 24 to Jan. 1 shutdown112027-03-01991.65

The weekends-only calendar finishes on Friday, February 12, 82 calendar days counting the start day. The federal calendar loses five weekdays and finishes a week later, on February 19. The shutdown calendar loses 11 weekdays and finishes on Monday, March 1, 99 calendar days after the start.

Iowa’s holiday list would also finish on February 19, because it trades Washington’s Birthday for the Friday after Thanksgiving. On an Iowa job without required winter work, though, the winter rule means no days would be charged in this window at all.

The ratio of calendar days to working days converts one count into the other. In the example it runs 1.37 with weekends only, 1.48 with federal holidays and 1.65 with the shutdown. Seven-fifths, or 1.40, is the ratio for a plain five-day week, and it understates the holiday span under either holiday calendar.

What the gap costs on a calendar-day contract

Suppose the same work sits under a contract that allows 90 calendar days from November 23, counting that day as day 1. The last allowed day is Saturday, February 20, 2027.

The federal calendar finishes on day 89, with one day to spare. The shutdown calendar finishes on day 99, 9 calendar days late. At the $2,000 per calendar day rate used in the example in the liquidated damages post, those 9 days come to $18,000, before the contractor’s own time-related field cost.

Setting it up in Excel

Microsoft’s documentation gives the syntax as WORKDAY.INTL(start_date, days, [weekend], [holidays]). The days argument counts workdays after the start date. The weekend argument takes a number, where 1 means Saturday and Sunday and 11 means Sunday only, or a seven-character string that starts with Monday and marks each non-workday with a 1. The holidays argument takes a range of dates in any order.

  1. Put each calendar’s non-work days in its own range, such as a column of the five federal dates and a second column that adds November 27 and December 24 through January 1.
  2. To count the start date as day 1, enter the day before as start_date. For the example, =WORKDAY.INTL(DATE(2026,11,22), 60, 1, Fed_Holidays) returns February 19, 2027, when Fed_Holidays names the range of federal dates.
  3. For a six-day week with Sundays off, use weekend number 11 or the string “0000001”.
  4. To check how much room is left before a contract date, use NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays]). Microsoft describes it as returning the number of whole workdays between two dates, with weekend days and listed holidays left out.

Weather days are a separate allowance on top of the calendar. The weather delay days post shows how to add expected weather days by month from NOAA climate normals, and the winter shift start post covers shorter daylight hours.

How to use it on your jobs

Export the non-work days from each active schedule calendar for November 2026 through February 2027. Compare them with the holiday list in each contract and with the dates the field plans to shut down. Where the field plans more days off than the schedule calendar holds, add them and record how far the forecast finish moves.

Track that movement at each update the same way the total float post tracks float. When the finish slips at the December or January update, check the calendar for missing holidays before reviewing the logic.

To start, pick one job with a calendar-day completion date. Run WORKDAY.INTL on its remaining working days with the schedule’s calendar and again with the field’s planned days off, and compare both dates to the contract completion date.