Hi!

You practically already have the solution:

=WORKDAY(TODAY(),3,holidays)

Holidays is a list of holidays that you want include in the calculation.

Biff

"telewats" wrote in
message ...

I'm trying to come up with a formula to calculate the third day out from
today, excluding weekends and holidays. I'm pretty sure I should use the
WORKDAY function, however I only know how to use this function when
using a specific date to add three to; not when using a rolling date.
Can someone help?


--
telewats
------------------------------------------------------------------------
telewats's Profile:
http://www.excelforum.com/member.php...o&userid=30270
View this thread: http://www.excelforum.com/showthread...hreadid=501177