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

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

Thanks Biff! I appreciate the help. I'm confused on just one part...
how do I establish holidays? Do I enter them in VBA or just in the
=WORKDAY formula or somewhere else?


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

Hi
Just set up a range of cells somewhere e.g. H1:H10 with the individual
holiday dates in them.
InsertNamedefineHolidaysRefers to = H1:H10

--
Regards

Roger Govier


"telewats" wrote
in message ...

Thanks Biff! I appreciate the help. I'm confused on just one part...
how do I establish holidays? Do I enter them in VBA or just in the
=WORKDAY formula or somewhere else?


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