We help IT Professionals succeed at work.

use following workday

pdvsa
pdvsa asked
on
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)
Comment
Watch Question

Phillip BurtonDirector, Practice Manager and Computing Consultant
Awarded 2014
Top Expert 2014

Commented:
=WORKDAY(EDATE(H196,6)+60,1,Holidays_US_Jap)
Most Valuable Expert 2013

Commented:
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
pdvsaProject finance

Author

Commented:
Hello, I am out of town at the moment.  Is one better than the other?  

Thank you
Most Valuable Expert 2013
Commented:
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
pdvsaProject finance

Author

Commented:
Ahhhh I see.  Very technical.  Glad I know now.  

Thank you once again