If your team plans in Google Sheets rather than Excel, the good news is short: the business day functions are the same, with the same names, the same syntax and the same quirks. You can calculate business days in Google Sheets with NETWORKDAYS, remove holidays with a list, switch weekends with NETWORKDAYS.INTL, and add days with WORKDAY. This guide sets up a clean example, including the one Sheets-specific trap that makes a correct formula display a date in 1900.
The basic setup
Put a start date in A2 and an end date in B2, then =NETWORKDAYS(A2,B2) in C2. Sheets counts the Monday to Friday days between the two dates, including both endpoints when they are workdays - the same inclusive behavior as Excel, and the same one-day difference from deadline counting that our Excel guide explains. Type dates so Sheets recognizes them as dates (2026-02-13 or 2/13/2026 depending on your locale), or build them with =DATE(2026,2,13) to be unambiguous in a shared file. A date that Sheets has understood right-aligns and can be reformatted; a date it has taken as text cannot be counted at all. If a whole column arrives as text from an imported file, convert it with DATEVALUE in a helper column rather than retyping - the conversion either produces a real date or an error, and both outcomes tell you something useful about the data.
Worked example: adding the holiday tab
Create a second tab named Holidays and list the year's federal holidays down column A, each as a real date on its observed day. Now count from Friday, February 13 to Friday, February 27, 2026. Without holidays, =NETWORKDAYS(A2,B2) returns 11: the eleven weekdays in the span, both Fridays included. But Monday, February 16, 2026 is Washington's Birthday. Add the list - =NETWORKDAYS(A2,B2,Holidays!A2:A12) - and the answer becomes 10. Keep the Holidays tab in every planning workbook you own and refresh it each January; a shared team drive with one master list, pulled in by IMPORTRANGE, is the grown-up version of the same idea.

Adding days, custom weekends, and a live countdown
Three more formulas complete the toolkit. WORKDAY adds business days to a date: =WORKDAY(A2,10,Holidays!A2:A12) returns the date 10 business days after A2, start day not counted, matching deadline logic. NETWORKDAYS.INTL and WORKDAY.INTL take the same weekend codes as Excel - 7 for a Friday-Saturday weekend, 11 for Sunday only, or a seven-character string starting Monday - for teams whose week is not the standard one. And the formula teams actually live by: =NETWORKDAYS(TODAY(),B2,Holidays!A2:A12) counts the business days remaining until the deadline in B2 and updates itself every morning. Just remember it counts today when today is a working day; if your team reads "days remaining" as full days left after today, subtract 1 and say so in the column header. For a one-off count with no spreadsheet at all, the business days calculator does the same job in the browser, and the homepage calculator shows the holiday-adjusted figure for any two dates.
Sheets-specific traps
Two display quirks cause most of the confusion in Sheets. First, if a NETWORKDAYS result shows as a date in January 1900, the formula is fine and the cell formatting is not: the cell inherited a date format, and the count (a small number like 10) is being displayed as the tenth day of Sheets' calendar. Set Format, Number, Automatic or Number and the real count appears. Second, locale: a sheet set to a day-first locale reads 2/3/2026 as March 2, while a US-locale sheet reads February 3. In a file shared across countries, use ISO dates or the DATE function for anything typed by hand, and check File, Settings, Locale before you debug a formula that was never broken. Neither trap exists in the counting itself - both live in how dates get in and how numbers get shown, which is where spreadsheet errors prefer to hide.
Building a small deadline dashboard
The setup above becomes genuinely useful when it is pointed at a list of real work. Give a sheet four columns - task, deadline, business days left, and a plain-English status - and three of the four fill themselves. The days-left column is the TODAY formula from the previous section copied down the deadline column. The status column can be a simple nested IF: show "Overdue" when the count is negative, "Due this week" when it is 5 or fewer, and "On track" otherwise. Add conditional formatting that shades the days-left cell amber under 5 and red under 0, and a shared team sheet quietly becomes the thing people check in the Monday meeting. Two maintenance rules keep it trustworthy: the Holidays tab gets refreshed every January (an out-of-date list is the only way this dashboard lies), and deadlines are entered as dates, never typed as text like "next Friday", which no formula can count. Teams that outgrow the sheet can graduate the same columns to a project tool - but they usually find the sheet was doing the essential job: one honest number, updated daily, that everyone can see.
One more Sheets convenience worth knowing: because the file lives in a browser, the TODAY counts are always current when the sheet is opened - there is no stale copy on someone's desktop still showing last month's numbers. Share the file with view access for stakeholders and edit access for the team, and the count everyone argues from is the same count.
Frequently asked questions
What is the Google Sheets formula for business days between two dates?
NETWORKDAYS, the same function as Excel: =NETWORKDAYS(start_date, end_date, holidays). It counts the Monday to Friday days between the dates, including both endpoints, and removes any holidays in the range you pass as the third argument.
Does Google Sheets have NETWORKDAYS.INTL and WORKDAY?
Yes. Sheets includes NETWORKDAYS.INTL for custom weekends and WORKDAY plus WORKDAY.INTL for adding business days to a date, all with the same syntax and weekend codes as Excel.
How do I count business days remaining until a deadline in Sheets?
Use TODAY() as the start: =NETWORKDAYS(TODAY(), B2, Holidays), where B2 is the deadline. The count updates every day. Remember it includes today if today is a working day, because NETWORKDAYS counts both endpoints.
Why does my Sheets formula return a date instead of a number?
The cell is formatted as a date. NETWORKDAYS returns a plain number, but if the cell inherited date formatting, Sheets displays it as a day in 1900. Change the cell format to Number and the count appears.
Can I share one holiday list across several Sheets files?
Yes. Keep the master list in one sheet and pull it into others with IMPORTRANGE, or simply keep a Holidays tab in each workbook and refresh it every January. The important part is that the dates are real dates on their observed days.
