Hi

I should have said that you need to have the Analysis Toolpack loaded.
Go to ToolsAddins and select the tick box for Analysis Toolpak and click
OK.

Having put the formula in F2 amend it to lock the range of holiday dates as
follows by inserting $ signs as shown

=NETWORKDAYS(D2,E2,$H$1:$H$10)

then, hover with your cursor over the bottom right corner of the cell
containing the formula until it turns to a black cross.
Hold down the left mouse button and drag down and the formula will copy down
changing the references for the cells with dates, but holding the range of
cells with holiday dates as constant.



--
Regards
Roger Govier
"jenniss" wrote in message
...
in cells D & E i have a series of dates. I want to put a formular E - D =
calculated number of days and i also dont want it calculating weekend?

the purpose of this is excel to work out how many days it takes to serve a
document

is this possible and if so what is the formular please