Quick Links
Dates in Microsoft Excel are useful for tracking finances, orders, and sales.
For years, it’s possible for you to simply use theYEAR functionand a reference.
The syntax for each function is the same:
and
where you refer to the cell containing the date.
Chutima Chaochaiya/Shutterstock.com
Remember, the month is formatted as its numeric value.
it’s possible for you to do this for the month using theTEXT function.
you’ve got the option to also get the two-digit number for the year with this method.
Thevalueis the cell containing the date and theformat_codeis how you want to display the result.
Pulling a month or year out of a full date in Excel takes only a minute with these methods.
For more, check out these additionaldate and time functions in Excelyou might find useful.
