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.
| Date | Day | Holiday | OPM federal list | Iowa DOT list |
|---|---|---|---|---|
| 2026-11-26 | Thursday | Thanksgiving Day | Yes | Yes |
| 2026-11-27 | Friday | Friday after Thanksgiving | No | Yes |
| 2026-12-25 | Friday | Christmas Day | Yes | Yes |
| 2027-01-01 | Friday | New Year's Day | Yes | Yes |
| 2027-01-18 | Monday | Birthday of Martin Luther King, Jr. | Yes | Yes |
| 2027-02-15 | Monday | Washington's Birthday | Yes | No |
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:
- Weekends only.
- Weekends and the five OPM federal holidays in the window.
- 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.
| Calendar | Weekday holidays and shutdown days before finish | Finish date | Calendar days | Calendar days per working day |
|---|---|---|---|---|
| Weekends only | 0 | 2027-02-12 | 82 | 1.37 |
| Weekends and OPM federal holidays | 5 | 2027-02-19 | 89 | 1.48 |
| Federal holidays plus Nov. 27 and a Dec. 24 to Jan. 1 shutdown | 11 | 2027-03-01 | 99 | 1.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.
- 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.
- 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.
- For a six-day week with Sundays off, use weekend number 11 or the string “0000001”.
- 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.