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" <[email protected]> wrote in message
news:[email protected]...
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks