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([email protected] = 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


  • Unfortunately we're trying to only display a report for the previous days specifically so we can have it on the dashboard and have it compared to today's report in separate widget

  • Ahh that works out haha - thank you @Marta Lewis and @Paul Newcome !

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Happy to help. 👍️

    Please don't forget to mark the most appropriate response(s) as "helpful" so that others searching for a similar solution can know that one may be found here.