Hi Jenniss
Firtsly, I am having difficulty in keeping this going as a proper thread. My
newsreader won't let me do a further reply to a response froma reeply I have
already made, hence I am having to return to the original posting each time.

The formula works fine for me.
If you want to send me a copy of your file directly to me email address, I
will take a look at it for you and see if I can figure out what is wrong.

just remove the words NOSPAM from my address to send direct.

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