calculate dates

K

kevin.raway

I am trying to create an application to calculate a date that is 2 weeks from
today but I never want the date to be a weekend or holiday. The results I
want to run on someones desktop without them having to do anything. Any
thoughts?
 
B

Bob Phillips

Use

=WORKDAY(TODAY(),14)

WORKDAY is part of the Analysis Toolpak add-in, so you may to install that

--

HTH

RP
(remove nothere from the email address if mailing direct)


"[email protected]"
 
R

Ron Rosenfeld

I am trying to create an application to calculate a date that is 2 weeks from
today but I never want the date to be a weekend or holiday. The results I
want to run on someones desktop without them having to do anything. Any
thoughts?
Click to expand...

If I understand you correctly:

=WORKDAY(TODAY()+13,1,holidays)

Where 'holidays' is a named range containing all the holiday dates.

----------------------
If the WORKDAY function is not available, and returns the #NAME? error, install
and load the Analysis ToolPak add-in.

On the Tools menu, click Add-Ins.
In the Add-Ins available list, select the Analysis ToolPak box, and then click
OK.
If necessary, follow the instructions in the setup program.
 
Top