Nov 05, 2019
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!!
Nov 29, 2019
Have you tried using the WORKDAY_DIFF() function? Check out the details here: