Number of Overlapping Workdays in Two Date Ranges

Topic Labels: Formulas
1082 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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: