Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Count the working days of a month

Topic Labels: Dates & Timezones
849 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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: