Date Filtration based on a criteria

[DataPirate26]

Hello. I want to apply a formula on the (Schedule/Accessed) column . First we need to find out the days of the week for the Schedule/Accessed Column. Now if Today's date is (08/16/2021 - Monday ) Then the Dates that needs to be Filtered out from the Schedule/Accessed Column are - (Monday, Sunday, Saturday and Friday i.e 08/16/2021, 08/15/2021, 08/14/2021, 08/13/2021) 

Now If in Schedule/Accessed field today's Date is Tuesday then it needs to filter out only Today's Date and Yesterday's date i.e (Tuesday and Monday's ) Date. Same goes upto Friday. So if it is a Friday then it needs to filter out Friday's date and Thursday's Date. 

Only for Monday it should filter out from Friday to Monday. 

Can anyone help out with the formula for this. I have attached the Sample test workflow below. 

[atcodedog05]

Hi @DataPirate26 

Here is how you can do it.

Workflow:

I am calculating the logic is today is monday [filter date] is [current date] - 4 days else [filter date] is [current date] - 1 day

Hope this helps : )