Range of dates/day of week converted to specific date

[Grisham312]

I have a format with effective date ranges to and from with days of the week.  What would be the best way to get it into date specific format versus a range?

I'm adding and example of the Excel to this post.  I would appreciate any advice or direction.  

This is an example of my input: 

Also, this is an example of the output I'm trying to get. 

Thank you!

[binuacs]

@Grisham312 what is the logic to calculate the desired output?

[PhilipMannering]

Hi @Grisham312 

This should get you most of the way there,

[Qiu · Accepted solution]

A slight different approach.

[PhilipMannering]

@Qiu A better approach.

[Qiu]

@PhilipMannering 
Your words mean a lot😂