[Webinar] Streamline your web hosting managementRegister Today

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

Featured Post

Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

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