To exclude holidays from the computation, you have to provide the dates of
the holidays. See help on WORKDAY

Tyro

wrote in message
...
On Feb 19, 3:07 pm, "Tyro" wrote:
If you need to deal with workdays, excluding weekends and holidays, you
can
use the WORKDAY function. If your date is in A1 then =WORKDAY(A1,-7)
returns the date of the workday 7 days earlier. The WORKDAY function
requires installation of the Analysis Toolpak in versions of Excel 2007.
It
is present in Excel 2007.

Tyro


Worked like a charm!!!!! Thank you so much.... I didn't know about
the Workday function.... AWESOME!!! Again, thank you!!!