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 Number of Weekdays

Solved
Jump to Solution
69 3
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

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!

Of course!