?
Solved

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

Posted on 2015-01-14
4
Medium Priority
?
84 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 2000 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
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…

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