pdvsa
asked on
Last Business Day of the Quarter
Experts,
I am looking for a formula that I can drag down based on cell A1 that will return the last business day of the quarter but will default to the next previous workday if the business day lands on a holiday according to the holidays tab.
please see attached file.
thank you
End-of-Quarter-formula.xlsx
I am looking for a formula that I can drag down based on cell A1 that will return the last business day of the quarter but will default to the next previous workday if the business day lands on a holiday according to the holidays tab.
please see attached file.
thank you
End-of-Quarter-formula.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thank you. Perfect.
because you have to apply the validation multiple times in case the first date -1 is also a holiday