Vicki: I have a list of dates and I’m looking for a formula to calculate the previous workday only if the date in the list is a weekend or holiday.

Why: Accrue Fed Fund Interest Daily (Fed Funds Rate only published on Business Days).

This is mildly complex, because you need to be able to create a named range for the holidays, and after building the long formula, Excel will likely give you the date serial number instead of the formatted date.

Table of Contents
(0:00) Introduction
(0:23) Create a named range with holidays
(1:23) Excel formula to detect if date is a workday using NETWORKDAY function
(2:11) WORKDAY function to go back one work day
(3:15) Formatting serial numbers as dates