Yes,

=WORKDAY(date,3)

This is part of the Analysis Toolpak add-in, so that needs to be installed
(check it in ToolsAddins)

You don't need to fix holidays manually, if you create a named list, you can
include that as a further parameter in the formula.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"clegge" wrote in
message ...

is there a calendar function in excel that will allow me to add 3 days
to a *yyyymmdd * formatted date and skip weekends... Basically want to
derive a settlement date, which is always trade date +3.. i am given
the trade date... we only count buisness days... weekends are not
include - i dont care about holidays (can fix those manually)

thanks!!!!


--
clegge
------------------------------------------------------------------------
clegge's Profile:
http://www.excelforum.com/member.php...o&userid=29927
View this thread: http://www.excelforum.com/showthread...hreadid=500218