The Workday Function (Formula field type)

This workday function is used to calculate the number of workdays between two selected dates.

To use the workday function, you must have two date fields on your board.

Then go ahead create a formula field type using the workday function .

  1. Click on the + symbol to the right of the last field header in the Table view.

  2. This pops up a form page, on which you click on Field type to select the formula field.

    💡 Note: The formula field type is a system-generated field type

  3. Type in the Field Name and Description.

  4. Click on Next

  5. Type in the formula(click on a function to pick Workday Function and input field the two date fields),

    💡Note: Use a coma in between both fields to define them e.g WORK_DAYS('{Start}','{Stop}')

    💡 Note: The Syntax and Example give you an idea of what each function should look like when typing in the Formula.

  6. Mark, any of the corresponding Checkboxes to show a better representation of the field on the board.

  7. Click on Create Field

  8. Then go ahead to add or update the record under the two date fields to view the work days between.

Did this answer your question?