For example, you can create a column of the months of the year in a worksheet by typing in only the first month.

Microsoft Excel's Month and Weekday functions output numeric values for a given date. The Month function results in the month numbers, such as "3" for March or "12" for December. The Weekday ...