10 bus days, use preceding if lands on a workday or holiday


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
In the attached there seems to be an error for one of the dates and I am not sure why.

thank you.
pdvsaProject financeAsked:
Who is Participating?
johnb25Connect With a Mentor Commented:
I don't think it is an error; Fri Jan 16th is only 9 working days. You need to go to Tue 20th to get the 10 days.

pdvsaProject financeAuthor Commented:
John, I forgot how to count.  

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!
pdvsaProject financeAuthor Commented:
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.
Yes, I think that is correct.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.