Thank you, that is SOOOO cool! So may I ask how you gathered such expertise?

"daddylonglegs" wrote:


If you want to add 40 calendar days to a date in B1, but skip to the
next workday if this would give a weekend or holiday date.....

=WORKDAY(B1+39,1,A$1:A$11)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=493488