Hi,

Im using the below formula:

=WORKDAY(DATE(YEAR(C6),MONTH(C6),DAY(C6)),5,Holida y)

where C6 = 4/24/2008 in mm/dd/yyyy format and Holiday is a named range with
a list of holidays.

Im getting a #VALUE error. Pls help me to fix this problem.

The forumla works if I give 0, instead of 5 in the above formula...


TIA
- Joseph