Count the working days of a month

[sales_optimio]

Hello guys :slightly_smiling_face:

Simple question but can’t get the answer by myself.

Is it possible to count the number of working days in a month with a formula ?
For example in January there is 21 working days (i only count monday to friday not the week-end days)

Thanks a lot guys

[Justin_Barrett]

Welcome to the community, @sales_optimio! :grinning_face_with_big_eyes: The WORKDAY_DIFF() function will return the number of work days (Mon-Fri) between any two dates. You can also include an optional list of holiday dates to skip.

Read more here in the “Date and time functions” section:

Airtable Support

Formula field reference

Formulas may involve functions, numeric operations, logical operations, and text operations that operate on fields. For an overview of formula fields, please refer to the Guide to Formula, Lookup, ...