Hey Coda, please add a certain number of days to this date, but automatically exclude weekends.
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()
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.
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
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
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