How to obtain similar text values from a data range in the next column heading

Problem.xlsx

I have attached the file, kindly let me know how I will populate data of Weekday through the cells.
Is there a formula or function to populate data.

Hi,
neone kindly give me the solution, if you need any additional information, let me know.