The MONTH function in Excel returns an integer from 1 to 12, representing January to December. For example, type the formula = MONTH(TODAY()) or =MONTH(NOW()) without the quotation marks in a cell to display the current month number. Excel dates are stored as integers.