Try...

=WORKDAY(D3,32,A1:A10)

....where A1:A10 contains your list of holidays.

Hope this helps!

In article ,
"Erin D." <Erin wrote:

I am creating a schedule in Excel and would like to exclude weekends and
holidays. The formula that I have tried, and does not work is:

=workday(D3,-32)

I want to pick up the date in D3 and add 32 days, but exclude weekends and
holidays. Can anyone please help me with this?

Thanks!