Solved

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

Posted on 2015-01-14
77 Views
Experts,

I have to follow up on this question.

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,Holidays_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
0
Question by:pdvsa
• 2
• 2

LVL 6

Accepted Solution

johnb25 earned 500 total points
ID: 40550182
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.
(5,6,7,8,9,13,14,15,16,20)

John
0

Author Closing Comment

ID: 40551103
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!
0

Author Comment

ID: 40551105
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.
0

LVL 6

Expert Comment

ID: 40551121
Thanks.
Yes, I think that is correct.

John
0

## Featured Post

### Suggested Solutions

VLOOKUP to a Closed Workbook 22 65
Three Dimensional Journey Map in Excel 8 28
Macro 3 20
+1 to an even value 4 15
Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…