Solved

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

Posted on 2015-01-14
4
77 Views
Last Modified: 2015-01-15
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,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
Comment
Question by:pdvsa
  • 2
  • 2
4 Comments
 
LVL 6

Accepted Solution

by:
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

by:pdvsa
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

by:pdvsa
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

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

John
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
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…

762 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

22 Experts available now in Live!

Get 1:1 Help Now