Yes it can if you use NETWORKDAYS. You will need to have the Analysis
ToolPak installed, unless you have XL2007. Look it up in help for more
information.

Regards,
Fred.

"Clinton" wrote in message
...
i have the following formula to give a 2 day cycle for production which
will
skip saturdays and sundays. can it be made to miss other days such as
public
holidays also if they are put into a table or something.

IF(WEEKDAY(A1+2)=7,A1+4,IF(WEEKDAY(A1+2)=1,A1+4,A1 +2))

whe A1 is first date, formula is in B1:Z1