Help

Count the working days of a month

Topic Labels: Dates & Timezones
1401 1
cancel
Showing results for 
Search instead for 
Did you mean: 
sales_optimio
4 - Data Explorer
4 - Data Explorer

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 1

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: