FormuladrillMONTH practice
MONTH returns the month of a date as a number from 1 to 12. Below are the 1 Excel exercise on Formuladrill that use it, each checked instantly in your browser.
Syntax
MONTH(date)
What people get wrong
Combine with YEAR to group dates by month without changing the data.
Excel exercise that use MONTH
- Year and monthLevel 4Pro
Practice MONTH now
The free exercises work without an account. Pro unlocks every exercise, with worked solutions and progress saved to your account.
Start practicing free