Solved

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

Posted on 2015-01-14
4
82 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Pivot table - average if not zero 2 28
Modification to nested formula needed 2 25
question on substitute function 2 27
Pivot Table Help 6 18
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…
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

730 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