the AutoFill feature and do the following.
Insert serial numbers in column A
In column C, insert the list of months.
in column E, insert the list of days
. Delete column B and D.
January
1.February
2.March
3.April
4.May
5.June
6.July
7.August
8.September
9mOctober

Days
1.Monday
2.tuesday
3.Wednesday
4.Thursday
5.Friday
6.Saturday
7. Sunday
​