Change day range excel after entering month name excel

Question

I need to know if there is a way to change the whole 'day' range after entering a specific month name in a cell.

For example

Enter month: January

Enter year : 2018

Now when I enter February, the day range (mon,tue,wed...) changes automatically with accordance to 1st February till the end of the month.

Thank you.

I'm not sure what you actually want here. The EOMONTH function could come in handy to generate the date range for each month. — Tim Biegeleisen
Hello Tim, Got the solution below from Mr. Naveed. Thanks for the response though. :) — Fahad Ahmed

Naveed Ahmed Naveed Ahmed · Accepted Answer · 2018-03-30T05:41:44

you can use Date Functions and Custom Cell Date Formatting to display day name.

use this sheet