pdvsa
asked on
10 bus days, use preceding if lands on a workday or holiday
Experts,
I have to follow up on this question.
Please see attached.
I am not sure if I am using the correct formula
criteria: 10 bus days after and use preceding if lands on a workday or holiday
=WORKDAY(EOMONTH(A1,MOD(12 -MONTH(A1) ,1)),10,Ho lidays_US_ Jap)
In the attached there seems to be an error for one of the dates and I am not sure why.
thank you.
10-bus-days-and-use-preceding.xlsx
I have to follow up on this question.
Please see attached.
I am not sure if I am using the correct formula
criteria: 10 bus days after and use preceding if lands on a workday or holiday
=WORKDAY(EOMONTH(A1,MOD(12
In the attached there seems to be an error for one of the dates and I am not sure why.
thank you.
10-bus-days-and-use-preceding.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
I also think my title "use preceding" day if lands on a holiday is not applicable as the date will never land on a holiday or weekend as I am only counting business days.
Thanks.
Yes, I think that is correct.
John
Yes, I think that is correct.
John
ASKER
I didn't see there was a Japanese holiday on Monday 12. I completely missed that one. I did see the holiday Monday 19th for usa for MLK.
Thank goodness for EE and the experts on this site. I feel better now. Thank you for clearing that up!