Hi Erin

Use
=NETWORKDAYS(D3,E3,N1:N12)

Returns the number of whole working days between start_date and end_date. Working days exclude weekends and any dates identified in
holidays. Use NETWORKDAYS to calculate employee benefits that accrue based on the number of days worked during a specific term.

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

See Help for examples



--
Regards Ron de Bruin
http://www.rondebruin.nl



"Erin D." <Erin D.@discussions.microsoft.com> wrote in message news:BD5BCCE6-9C2F-4FDD-B1C6-859871318043@microsoft.com...
>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!
>
>