week day calculation if today is monday then pickup data from last Friday

[Arvs]

Dear All, trying to create formula- 

i need to  check entire row based on the previous date that is under " last updated"-

but if today is monday then  check date for last friday (excluding saturday and sunday)

2 condition :- 

trade status should be = open 

[caltang]

@Arvs if the above solved your need, kindly like & mark as accepted solution so that you may help others find the solution more quickly + to close the thread as is. Thanks!