=workday(A1,3)

you can also exclude holiday dates by putting them in a range, say M1:M10,
and using

=workday(A1,3,M1:M10)

Workday is part of the Analysis Toolpak addin, so that has to be installed
(ToolsAddins)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Suddes" wrote in message
...
Hello all, i am sure this is very simple but.....
I am trying to add 3 working days to a date and time and have the answer
displayed in dd/mmm hr:mmm format
so if i add 3 working days to 29/6/6 9:00 i would have the answer retrned
as
3-Jul 9:00

Thanks for your guidence

Suddes