Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Number of Overlapping Workdays in Two Date Ranges

Topic Labels: Formulas
657 1
Showing results for 
Search instead for 
Did you mean: 

For each record in my table, I have a Start_Date and an End_Date. These dates define a period of performance for each record.

Fiscal Quarter 1 begins on 7/1/2019 and ends on 9/30/2019.
FQ2 begins on 10/1/2019 and ends on 12/31/2019.
FQ3 begins on 1/1/2020 and ends on 3/31/2020.
FQ4 begins on 4/1/2020 and ends on 6/30/2020.

For each record, I want to determine how many Workdays (including holidays that fall on weekdays) of the period of performance fall within each FQ.

Any guidance in developing a Formula that can do this would be greatly appreciated. I am a Pro user, if that makes a difference. Thanks in advance!!

1 Reply 1

Have you tried using the WORKDAY_DIFF() function? Check out the details here: