pdvsa
asked on
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_U S_Jap)
Please see attached.
first-bus-day-of-year.xlsx
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
Please see attached.
first-bus-day-of-year.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