One way, put the holidays in a column. Name it, say, "holidays". Assume
A1 contains your end date. Then

=A1-TODAY()-SUMPRODUCT(--(holidays>=TODAY()),--(holidays<=A1))




In article <BFCE122A-B895-440F-B1F3-2F0BD5510AB6@microsoft.com>,
"Jan Buckley" <JanBuckley@discussions.microsoft.com> wrote:

> How can I use this same formula, or another one if available, to calculate
> the days, and exclude the holidays. I tried to use workdays, but that
> excludes the weekends also. Thanks.