Working with Months in Excel


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.

Months Basics

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.

Excel MONTH function screenshot

Figure 1

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.

Year and DAY functions screenshot

Figure 2

Other Resources

There is a wealth of resources available for Excel functions. If you want to know more, here are a few sites to check out:


Image credit:

Angela Nino - Versitas Editor

Leave a Reply

Your email address will not be published. Required fields are marked *