Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Count Number of Weekdays

Solved
Jump to Solution
1717 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!