software

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: www.excelforum.com/member.php...oamp;userid=29927
View this thread: www.excelforum.com/showthread...hreadid=500218Yes,

=WORKDAY(date,3)

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

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)

quot;cleggequot; gt; wrote in
message ...
gt;
gt; is there a calendar function in excel that will allow me to add 3 days
gt; to a *yyyymmdd * formatted date and skip weekends... Basically want to
gt; derive a settlement date, which is always trade date 3.. i am given
gt; the trade date... we only count buisness days... weekends are not
gt; include - i dont care about holidays (can fix those manually)
gt;
gt; thanks!!!!
gt;
gt;
gt; --
gt; clegge
gt; ------------------------------------------------------------------------
gt; clegge's Profile:
www.excelforum.com/member.php...oamp;userid=29927
gt; View this thread: www.excelforum.com/showthread...hreadid=500218
gt;
Hi

Try
=WORKDAY(DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2)), 3)
If you want to include holidays as well, then create a range of cells
containing the holiday dates (as true Excel type dates e.g. 12/25/2006)
and include that in the formula as
=WORKDAY(DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2)), 3,$H$1:$H$10) where
H1:H10 is where you have entered your holidays.

If your existing dates are true Excel dates, but just formatted to
display as yyyymmdd, then you don't need the conversion to date
=WORKDAY(A1,3,$H$1:$H$10)

--
Regards

Roger Govierquot;cleggequot; gt; wrote in
message ...
gt;
gt; is there a calendar function in excel that will allow me to add 3 days
gt; to a *yyyymmdd * formatted date and skip weekends... Basically want
gt; to
gt; derive a settlement date, which is always trade date 3.. i am given
gt; the trade date... we only count buisness days... weekends are not
gt; include - i dont care about holidays (can fix those manually)
gt;
gt; thanks!!!!
gt;
gt;
gt; --
gt; clegge
gt; ------------------------------------------------------------------------
gt; clegge's Profile:
gt; www.excelforum.com/member.php...oamp;userid=29927
gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=500218
gt;