MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Next work day function that skips holidays?


Posted by Ben on August 09, 2000 7:14 PM

=WORKDAY(A1,1) is very nice. Is there a function or macro that skips designated days (holidays)?


Posted by david on August 10, 0100 3:10 AM

sorry this is the link
http://edc.bizhosting.com/english/dates.htm

Posted by mike faulkner on August 11, 0100 8:42 AM

Try WEEKDAYS (you need the analysis toolpak installed for it to work though).

You do have to define your own holiday though - I guess that's either a + or - depending on your situation.

Posted by Ben on August 22, 0100 9:37 PM

Thanks

Posted by david on August 09, 0100 11:05 PM

intersting site
http://edc.bizhosting.com/english/index.htm