Ron Coderre Wrote:

=WORKDAY(A1,4+OR(WEEKDAY(A1,2)5,ISNUMBER(MATCH(A1 ,$J$1:$J$10,0))),$J$1:$J$10)


Hi Ron,

doesn't look like there was a need to consider start date on a holida
but if there was you could use

=WORKDAY(WORKDAY(A1,-1,J$1:J$10),5,J$1:J$10

--
daddylongleg
-----------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...fo&userid=3048
View this thread: http://www.excelforum.com/showthread.php?threadid=53847