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.
