Solved

First Business Day of the year

Posted on 2015-01-08
2
67 Views
Last Modified: 2015-01-08
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
Comment
Question by:pdvsa
2 Comments
 
LVL 24

Accepted Solution

by:
Phillip Burton earned 500 total points
Comment Utility
=WORKDAY(EOMONTH(A1,11),1,Holidays_US_Jap)
0
 

Author Closing Comment

by:pdvsa
Comment Utility
Thank you!  worked perfectly.
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Suggested Solutions

A2 = A1 That kind of cell reference is relative.  If you copy it from A2 to B2, then B2 will get this: B2 = B1 That's all fine and good, but if you then insert a new row above row 2, you'll find: A3 = A1 B3 = B1 This is intentional. …
Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now