use following workday

I know the below uses the preceding but I am not certain how to chagne it to the following workday if the date lands on a weekend or holiday.  

=WORKDAY(EDATE(H196,6)+60+1,-1,Holidays_US_Jap)
pdvsaProject financeAsked:
Who is Participating?
 
barry houdiniCommented:
The results will be different in some cases - I'm assuming that if you add 6 months to the date in H196 and then add 60 days, then if that day is, for example, a Thursday (which isn't a holiday) then you want the formula to return that date. That's what my formula does - but if the date you land on is a holiday or weekend day the formula will give you the following workday.

Phillips's version will always give you the following workday, so if the original date you land on is a Thursday my version will return that date, Phillip's will give you the Friday.

regards, barry
0
 
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
=WORKDAY(EDATE(H196,6)+60,1,Holidays_US_Jap)
0
 
barry houdiniCommented:
Generically your original formula gets the calculated date, adds 1 and then gets the previous WORKDAY.....but you now need to get the calculated date, subtract 1 and get the next WORKDAY, so for that the +1 becomes -1 and the 1 becomes -1, i.e.

=WORKDAY(EDATE(H196,6)+60-1,1,Holidays_US_Jap)

regards, barry
0
 
pdvsaProject financeAuthor Commented:
Hello, I am out of town at the moment.  Is one better than the other?  

Thank you
0
 
pdvsaProject financeAuthor Commented:
Ahhhh I see.  Very technical.  Glad I know now.  

Thank you once again
0
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.