Excel MONTH Function - extract the month from a date | Excel One-Minute Quick Reference

Posted on: 06/20/2021

The MONTH function in Excel allows you to extract the month from the date. The MONTH function returns a number from 1 to 12.

January would be the number 1
July would be the number 7
December would be the number 12.

In this article and video below, I show you how the month function works in Excel, the formula to use, reference the fields, formatting it so that you only see the month and nothing else.

Syntax of the MONTH function

MONTH (serial_number)

Example:

If A1 contains the date 8/15/2024, the month function will return the number 8.

=MONTH(A1)

YouTube Video on the MONTH Function

Other Excel articles

Optimizing Microsoft Excel Files for Better Performance

Posted by Chris Menard on 04/05/2024

Excel Business Functions - Functions everyone should know - Excel Essentials Training

Posted by Chris Menard on 08/18/2023

Excel Print Options - Set Print Area, Print Selection, Margins, and Printing Gridlines

Posted by Chris Menard on 07/11/2023

Excel Page Break Preview and Inserting Page Breaks - Excel Essentials

Posted by Chris Menard on 06/13/2023

Excel - Copy and Move Data - Excel Essentials

Posted by Chris Menard on 06/11/2023

Excel - Getting Started with Autofill - MUST KNOW FEATURE

Posted by Chris Menard on 05/28/2023

Excel Essential Skills - Rows & Columns and the EVIL Merge and Center

Posted by Chris Menard on 05/26/2023

Excel - switch between relative, absolute, and mixed references

Posted by Chris Menard on 05/01/2023

Chris Menard

Chris Menard is a certified Microsoft Trainer (MCT) and works as a full-time Trainer at BakerHostetler - one of the largest law firms in the US. He runs a YouTube channel with 900+ technology videos that cover various tools such as Excel, Word, Zoom, Teams, Gmail, Google Calendar, and Outlook. To date, the channel has helped over 20 million viewers. Menard also does 2 to 3 public speaking events every year, presenting at the Administrative Professional Conference (APC), the EA Ignite Conference, the Support Staff Conference, the University of Georgia, and CPA conferences. You can connect with him on LinkedIn at https://chrismenardtraining.com/linkedin or watch his videos on YouTube at https://chrismenardtraining.com/youtube.