Trying to calculate third day from today...

T

telewats

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?
 
B

Biff

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
 
T

telewats

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?
 
R

Roger Govier

Hi
Just set up a range of cells somewhere e.g. H1:H10 with the individual
holiday dates in them.
Insert>Name>define>Holidays>Refers to = H1:H10
 
Top