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