For many of us, we use dates in calculations in Excel. In some cases, you may need to use months in your accounting, finance, inventory or other functions. You may not think you need the Excel MONTH function, but if you are doing your calculation the long way, you’ll appreciate the shortcut.
Very similar to the MONTH function are the YEAR and DAY functions. They can pull a year or day of the month number from a date to use in a calculation or for queries. For example, the MONTH function for a cell that contains the date of October 15, 2017 would end up with a number of 10. The YEAR function would pull 2017 and the DAY function would result in a 15.
The MONTH function will return the month associated with a date in a cell. For example: =MONTH (C7) would pull the month from the date that is in cell C7. Or, combine the MONTH and TODAY functions to show the number of the current month with =MONTH (TODAY()).
In the Figure 1 example below, I show the MONTH function result and the underlying formula for two separate dates with different date formatting.
YEAR and DAY Functions
The YEAR and DAY functions work just like the MONTH function worked in Figure 1. They include the function name with the cell reference in parenthesis. In Figure 2, the YEAR and DAY functions are shown with the same dates as the MONTH function used.
There is a wealth of resources available for Excel functions. If you want to know more, here are a few sites to check out:
- Date and Time Functions
- MONTH function and Serial Numbers
- More about the MONTH function
- Excel Text Functions
- Excel Functions by Category
Image credit: https://www.flickr.com/photos/studiocurve/