Skip to main content

Count the working days of a month

  • January 19, 2022
  • 1 reply
  • 27 views

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

1 reply

Justin_Barrett
Forum|alt.badge.img+21

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: