Gallery
WorkDay, NetWorkingDays
Share
Explore

icon picker
WorkDay, NetWorkingDays

Formulas: WorkDay() and NetWorkingDays()
Category: Dates/Times
workstation.svg
WorkDay()
Adds a specified number of workdays to a date
or stated otherwise...
Hey Coda, please add a certain number of days to this date, but automatically exclude weekends.
wednesday.svg
NetWorkingDays()
Tallies number of workdays between dates
said differently...
Hey Coda, tell me how many days are between these two dates, but exclude weekends.

These formulas each have three parameters. Two are shared and one is unique for each formula. First, the unique parameter.
WorkDay()
calendar-1.svg
NumWorkingDays

Workday(StartDate, NumWorkingDays, Holidays)

Number of Mon-Fri days to add.
NetWorkingDays()
end-call.svg
EndDate

NetWorkingDays(StartDate, EndDate, Holidays)

The date you want to count to.
Next are the two shared parameters.
play (1) (1).svg
StartDate

Workday(StartDate, NumWorkingDays, Holidays)

The date you want to start from.
christmas-gift.svg
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.
Yellow Column: Measuring how many total days away the estimated completion of a task is.
Gray Column: Measuring the number of actual workdays (excluding weekends and holidays) that will be allocated towards this task.
Task
Start Date
Effort
Estimated Completion
Total Days Away
Workdays
1
Submit Marketing Plan
10/11/2022
00
11
10/26/2022
14 days 12 hrs
12 days
2
Launch Marketing Campaign
11/1/2022
00
6
11/9/2022
7 days 12 hrs
7 days
3
Review subscriptions
1/1/2023
00
18
1/25/2023
23 days 11 hrs
18 days
4
Create new Coda workflow
1/17/2023
00
9
1/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!
Best practice around entering Holidays so your formulas work as designed is to create a distinct holidays table and reference that as a list in your formula.
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

Done
Create a button that will notify a user when they have 5 workdays to complete a task
Done
Done

Share
 
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.