Business Days andHolidays Function
Posted on 2014-11-01
I have rows of data and have a formula as below but mos tof the formulas do not have the part about WORKDAY and HOLIDAYS as shown below. It will take me a long time to manually change the formulas to add the WORKDAY and HOLIDAY (named ranged of HOliday_US_Jap)
I imagine there is a function I can use to apply to a certain column (ie column H has all the dates). Basically, if the column of dates contains either date on the weekend or is a date that is a HOLIDAY then move forward to the next available day that is a weekday and is not a holiday. Hope that makes sense. I cant simply use a find and replace as the formulas are vastly different. I was only adding the WORKDAY and HOLIDAY parts.
here is the formula. I have modified with the bold