We have a process we are automating that we need to go back to the prior business day not just date=TODAY()-1. This is not for scheduling. This is for filtering a datatable. Does anyone know how to accomplish this? It will need to incorporate not only weekends but also holidays.
I will appreciate any guidance you can provide.