Hi,

I have put in a formula to calculate the no. of working days between
4/1/2004 (in C2) and 3/31/2005 (E2).

Started work on 11/9/2004 (in J2 cell)

The formula i
=ROUND(IF(DATEVALUE(J2)<=DATEVALUE(BAI!$C$2),(DATE VALUE(BAI!$E$2)-DATEVALUE(BAI!$C$2)+1),(IF(AND((DATEVALUE(J2)BAI! $C$2),(DATEVALUE(J2)<=DATEVALUE(BAI!$E$2))),(DATEV ALUE(BAI!$E$2)-DATEVALUE(J2)+1),0))),2)

However, the formula returns #VALUE!

Can someone help.

Thank you very much

Jessica