Skip to content
WorkDay, NetWorkingDays
WorkDay, NetWorkingDays
Time to master some Coda formulas
Formulas: WorkDay() and NetWorkingDays()
Category: Dates/Times
WorkDay()Adds a specified number of workdays to a date
or stated otherwise...
NetWorkingDays()Tallies number of workdays between dates
said differently...
These formulas each have three parameters. Two are shared and one is unique for each formula. First, the unique parameter.
WorkDay()
NumWorkingDays
Workday(StartDate, NumWorkingDays, Holidays)
Number of Mon-Fri days to add.NetWorkingDays()
EndDate
NetWorkingDays(StartDate, EndDate, Holidays)
The date you want to count to.Next are the two shared parameters.
StartDate
Workday(StartDate, NumWorkingDays, Holidays)
The date you want to start from. 
Holidays
NetWorkingDays(StartDate, EndDate, Holidays)
Days you want to exclude.
Estimating Staff Capacity
Within a business, it’s critical to estimate your staff’s capacity and properly allocate staffing resources. WorkDay() and NetWorkingDays() help you do just that!
Notice the yellow and gray columns below.
Task
Start Date
Effort
Estimated Completion
Total Days Away
Workdays
1
Submit Marketing Plan
10/11/2022
00
1110/26/2022
14 days 12 hrs
12 days
2
Launch Marketing Campaign
11/1/2022
00
611/9/2022
7 days 12 hrs
7 days
3
Review subscriptions
1/1/2023
00
181/25/2023
23 days 11 hrs
18 days
4
Create new Coda workflow
1/17/2023
00
91/30/2023
12 days 11 hrs
10 days
There are no rows in this table
WorkDay() and NetWorkingDays() are very helpful for visualizing and planning the completion of tasks by more faithfully capturing the hours/days which people work.
Accounting for Holidays
Both formulas take an optional parameter for Holidays. Time after time, though, I see individuals plugging dates into this parameter in painful or laborious ways, or just not using this parameter at all!
Here is the Holidays table that is being used as an input for the above tasks table. Click into the Workdays column or the Estimated Completion column in the table above to see how this table is referenced.
Dec 31, 2022
Holiday
Holiday Date
1
New Year Day
1/1/2022
2
Martin Luther King Jr. Day
1/20/2022
3
Belly Laugh Day
1/24/2022
4
Groundhog Day
2/2/2022
5
Valentine's Day
2/14/2022
6
St. Patrick's Day
3/17/2022
7
April Fool's Day
4/1/2022
8
Easter
4/12/2022
9
Mother's Day
5/10/2022
10
4th of July
7/4/2022
11
Veterans Day
11/11/2022
12
Thanksgiving Day
11/26/2022
13
Christmas Day
12/25/2022
There are no rows in this table
Practice: Use NetWorkingDays() to estimate task completion
Done
Create a button that will notify a user when they have 5 workdays to complete a task
Done
Determine the date you should start working on a project given a target launch date
Done
Ready to master Coda yourself?
Join the Coda school today and discover the “formula” for success! With over 100 formulas to choose from, your mind will be blown with how easy it is to use Coda (coda.io). And let's not forget about the tons of other awesome content waiting for you on this platform!
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.