Hello Bryan,

It sounds like you are trying to get the number of workdays in the immediate
preceding 365 days from today. Try this:
=SUMPRODUCT(--($A5:$A2936=TODAY()-365),--($A5:$A2936<=TODAY()),--($c5:$c29360))

Let me know if this works.

Did the last formula I posted for you work?

Tom