Welcome to the forum.

=WORKDAY(TODAY(), -1, A1:A10)

... where A1:A10 contains a list of holidays as Excel dates.