Need to find cheque information AS PER SPECIFIC WEEKDAY ONLY - please refer attachment

Guys it is me again

Sorry for all the trouble I cause.

On my previous thread I needed to sort-out my Bank depositing cheques.

Now I also have some cash cheques.

We release these only on 2 days of the week.

Sunday and Wednesday.

Can I find the cheque info by code as below,

On Sunday :
I need to know cheques which are due on Tuesday, Wednesday and Thursday.

On Wednesday :
I need to know cheques which are due on Friday, Saturday, Sunday and Monday.

Please refer attachment to see how I need my outcome.

Thank you.


NOTE : If you are Pete_UK,

Bro I am sure this is a piece of cake for you.

My request is can we jam this equation(This Thread) and what you solved me before as per Colomn D, which I mentioned as "DEPOSIT" if you can remember,

eg ; If Deposit, do what the previous (solved) thread did.
if Cash(This thread) do this

It is only a request. Then I can do 2 jobs in one colomn as it would make much easier for me to do the color formatting depending on it's out come(Which I mean "DL"/"CL")


Book2 - CASH.xlsx

LOL,

I cracked it myself.

Thanks to the knowledge gathered through Pete_uk.

=IF(D10="CASH",IF(WEEKDAY($C$8,2)=3,IF(AND(B10>=$C$8+2,B10<=$C$8+5),"CL","-"),IF(WEEKDAY($C$8,2)=7,IF(AND(B10>=$C$8+2,B10<=$C$8+4),"CL","-"),"-")))