Return last workday

Ryan Nix

Hi,

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?

Marta Lewis

@Ryan Nix, try this formula in a 'Previous Workday' column (formatted as a Date column):

=WORKDAY(Date@row, -1)

Then you could sort your report in chronological order, choice of date column?

Paul Newcome

You can combine @Marta Lewis's solution with your current formula.

=IF(Date@row = WORKDAY(Date@row, -1), 1, 0)

Marta Lewis

@Ryan Nix, try this formula in a 'Previous Workday' column (formatted as a Date column):

=WORKDAY(Date@row, -1)

Then you could sort your report in chronological order, choice of date column?

Ryan Nix

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

Paul Newcome

You can combine @Marta Lewis's solution with your current formula.

=IF(Date@row = WORKDAY(Date@row, -1), 1, 0)

Ryan Nix

Ahh that works out haha - thank you @Marta Lewis and @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.