WorkDay, NetWorkingDays

Explore

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...

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

Submit Marketing Plan

10/11/2022

10/26/2022

14 days 12 hrs

12 days

Launch Marketing Campaign

11/1/2022

11/9/2022

7 days 12 hrs

7 days

Review subscriptions

1/1/2023

1/25/2023

23 days 11 hrs

18 days

Create new Coda workflow

1/17/2023

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

New Year Day

1/1/2022

Martin Luther King Jr. Day

1/20/2022

Belly Laugh Day

1/24/2022

Groundhog Day

2/2/2022

Valentine's Day

2/14/2022

St. Patrick's Day

3/17/2022

April Fool's Day

4/1/2022

Easter

4/12/2022

Mother's Day

5/10/2022

4th of July

7/4/2022

Veterans Day

11/11/2022

Thanksgiving Day

11/26/2022

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!

⁠

Coda School Take your Coda formulas from "I can get by" to "I can do anything" with a fully interactive course designed to be taken at your own pace, with accountability and community built in. www.codaschool.io⁠

⁠

More Formulas⁠

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.