Formula for a Date finder and auto filler

Hi All,

Is there a formula that finds the date based on a value that contains the month's name? What the file attached is a calendar looking range for a month's work week where MON to FRI are the workdays and SAT SUN being weekends. Weekends are not needed to be in the formula, only the workdays.

What I am hoping to accomplish is by typing the Month like Jan-19 in Cell A1, it will prefil the cells under Row 2 with their respective dates based on the arrangement of the days shown.

The purpose is that it is tied to a lookup table that ranges the whole 365 days of year 2019. The hlookup works as long as the dates are filled. It is working if manually inputed per cell, like I have to check the calendar and manually type what dates fall every monday, tuesday, wednesday etc. I was just hoping there is a shortcut way to make the process much faster like a QOL improvement.

Thank you so much!

Hello Bo_Ry! This works! Thank you so much! Wow this is a really long and complicated one. +Rep for you!