=NETWORKDAYS(Start_date,End_date,holidays)

Holidays would be a range containing the dates of public holidays you wish
to de excluded from your calculation.
for example in your case, if you entered the range of holiday dates in cells
H1:H10
=NETWORKDAYS(D1,E1,H1:H10)

--
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