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
pdvsaProject financeAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Phillip BurtonConnect With a Mentor Director, Practice Manager and Computing ConsultantCommented:
=WORKDAY(EOMONTH(A1,3)+1,-1,Holidays_US_Jap)
0
 
FarWestCommented:
is it a requirement to be macro free workbook? or you can use VBA in the sheet
because you have to apply the validation multiple times in case the first date -1 is also a holiday
0
 
pdvsaProject financeAuthor Commented:
thank you.  Perfect.
0
All Courses

From novice to tech pro — start learning today.