Skip to main content

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.
 

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

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!

Reply


Terms & Conditions