If you're trying to calculate the number of workdays between 2 dates the
function you need is NETWORKDAYS not WORKDAY. To count weekdays and
Saturdays
=NETWORKDAYS(A1,B1,holidays)+INT((WEEKDAY(A1)+B1-A1)/7)
where A1 contains start date and B1 end date and holidays is a named
range containing (weekday) holiday dates
--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile:
http://www.excelforum.com/member.php...o&userid=30486
View this thread:
http://www.excelforum.com/showthread...hreadid=515264