But there is a magic way to handle it and its a feature that excel provides called”Fill Handle”
As soon as you select the cell that you want to create a series like below

When the same I have with my colleague , he was really a lot relaxed .
He was able to create the template in much lesser time than he expected it may take, how cool right?

Fill Series : Selecting this will fill the values based on the first cell in the selection range.
Fill Without Formatting : Copies the entire cells including the formulas and formatting.
Fill Days : Selecting this will fill the Day values based on the first cell in the selection range.
Fill Weekdays : Selecting this will fill the Weekday values based on the first cell in the selection range (Excludes Sunday and Saturday).
Fill Months : Selecting this will fill the Month values based on the first cell in the selection range.
Fill Years : Selecting this will fill the Year values based on the first cell in the selection range.
By the way , you can experiment by two or more start cells!!!
Like Selecting alternate numbers, even months and so on….