Hi

check out the NETWORKDAYS function
syntax:
NETWORKDAYS(start_date,end_date,holidays)

this counts the number of days between the start date & end date, excluding
any weekends and any holidays you enter. This function needs the Analysis
Tool-Pak installed.
--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Sanjay Shah" wrote in message
...