Skip to Content
0

Omit the weekend from "Previous Days" search

Apr 18, 2017 at 04:18 PM

27

avatar image
I built a report to find work that was completed within the past 24 hours and it is scheduled to go to my manager every morning. The problem comes Monday morning when there was no work completed on Sunday. Is there a way to see Fridays work on the following Monday?
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Kuldeep Ghosh Apr 19, 2017 at 01:55 PM
0

You can create a filter to look for previous days:

=If (DayName(CurrentDate())="Monday") Then RelativeDate(CurrentDate();-2) Else RelativeDate(CurrentDate();-1)

See if this works for you.

Share
10 |10000 characters needed characters left characters exceeded