Excel 365: How do determine if a date is a workday?

[psycoperl]

I am working on a time card template in excel. I want to use a formula to determine if the date in Column A is a workday (that is not a weekend, Sat / Sun, and not on our list of holidays/closures)
I was looking at the Workday function but it did not return a true/false value it just returned a number.

Your suggestions are greatly appreciated.

 

[Fluff]

How about

=WORKDAY(A2-1,1)=A2

 

[Joe4]

You can use the method shown here: Date is workday

 

[Joe4]

How about

=WORKDAY(A2-1,1)=A2

or

=WEEKDAY(A2,2)<6

I don't think that section option will account for holidays!

 

[Fluff]

Good point, forgot about the holidays, so I've removed it.