Improve company productivity with a Business Account.Sign Up

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

First Business Day of the year

experts,

I need a formula for the first business day of the year taking into account the holiday tab.
The formula seems to not be correct if I drag it down a few cells.  

=WORKDAY(EOMONTH(A1,MOD(12-MONTH(A1),12))-1,1,Holidays_US_Jap)
Please see attached.
first-bus-day-of-year.xlsx
0
pdvsa
Asked:
pdvsa
1 Solution
 
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
=WORKDAY(EOMONTH(A1,11),1,Holidays_US_Jap)
0
 
pdvsaProject financeAuthor Commented:
Thank you!  worked perfectly.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

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