Extract week start and weekend day exclude holidays & weekday excel formula

[amartakale]

I want Date formula (Extract week start and weekend day exclude holidays & weekday excel formula)

[大灰狼1976]

Not achieving the desired results, i did it with another way(mark used conditional formatting).
Please refer to the Attachment.

[amartakale]

Thanks sir,but not desired results come which I want.

[大灰狼1976]

Yes i know, it's just a hint that i think if useful to you.