List all the Mondays, Wednesdays and Fridays between Two Date

[PeterDavids]

Dear All

I have a date range and a need a formula that lists all the Mondays, Wednesdays and Fridays in the range? The days of to be in the dd-mmm-yyyy formats.

Thank you
Peter

 

[gaz_chops]

Dear gaz_chops
Please forgive the ignorance but I just can't get the formula's to get the results I am looking for. Just NOT understanding the formula. Attaching image of the result I'm looking for.
View attachment 16685

Is that how your sheet actually looks, you will have 1 start/end date and multiple outputs to list various days between?

 

[gaz_chops]

 

[PeterDavids]

Thats correct.

 

[gaz_chops]

Is my last post what you are after?

 

[PeterDavids]

Thanks so much for your help, really appreciate it. [Solved my headache].
Does one still mark the thread as solved? have not used the site in a while.

 

[gaz_chops]

You're welcome, no option to mark as solved.