0Fill dates Automatically in worksheet cells.
The 1st and 2nd Format are known by Most Excel Users, however, 3rd - 5th Formats are lesser known.
3rd format - Only Weekdays
4th format - Only Months*
5th format - Only Years*
*could be any date, not necessarily 1st day
Step 1) Fill 1st 2 cells. e.g. in 1st 2 cells, type 01-Jan-19 & 02-Feb-19
Step 2) Select the 2 cells.
Drag the fill handle, at the right-bottom corner of 2nd cell
Step 3) Click on Auto Fill Options drop-down
As per requirement, choose the Option.
Source + to learn more, click → Microsoft Official Website
