Return last workday

Ryan Nix
Ryan Nix ✭✭
edited 06/14/22 in Add Ons and Integrations


I'm trying to create a report that will display the items for the previous work day. I initially tried creating a helper column with the following formula =IF(Date@row = TODAY(-1), 1, 0) which works great for Tuesday through Friday but on Mondays, it returns for Sunday. Is there a way to have it return the last weekday rather than the weekends?


Best Answers