Help

Count Number of Weekdays

Solved
Jump to Solution
1382 3
cancel
Showing results for 
Search instead for 
Did you mean: 
aleajewelle
5 - Automation Enthusiast
5 - Automation Enthusiast

Is there a way to count the number of weekdays between a date range? 

I am currently using the following formula to count the number of days between the FROM and TO DATE:

DATETIME_DIFF({To Date}, {From Date}, 'days')+1
 
If the date range includes a weekend, I only want to include the number of weekdays.
 
1 Solution

Accepted Solutions
Micki_O_Neil
7 - App Architect
7 - App Architect

Yes! You can use WORKDAY_DIFF().  There's a really helpful list of all the formulas and how to use them here in the Formula Playground base: https://support.airtable.com/docs/en/formula-field-reference?highlight=formula%20playground

See Solution in Thread

3 Replies 3
Micki_O_Neil
7 - App Architect
7 - App Architect

Yes! You can use WORKDAY_DIFF().  There's a really helpful list of all the formulas and how to use them here in the Formula Playground base: https://support.airtable.com/docs/en/formula-field-reference?highlight=formula%20playground

Thank you @Micki_O_Neil ! I was looking for the wrong keyword, "weekday". This helped a lot! Thanks again!

Micki_O_Neil
7 - App Architect
7 - App Architect

Of course!