Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 130
  • Last Modified:

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
0
pdvsa
Asked:
pdvsa
1 Solution
 
Phillip BurtonCommented:
=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
 
pdvsaAuthor Commented:
thank you.  Perfect.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now