Workday syntax

Originally Posted by protonLeah

It's: =C2+D2+E2+F2
Today's date is the number of days since 1/1/1900 (41082). If you add 3 to it, Excel will convert that new number to a calender date, etc

But I want to use workday to skip the weekends and hopefully the holidays and the c2+d2+e2+f2 just gives me net calendar days
Thanks
Alan

Edit,
This does work
=WORKDAY((C2),(D2+E2+F2))
Thanks
Alan
edit2
and this got the holiday
=WORKDAY((C2),(D2+E2+F2),( J$2))

Thanks!!