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

Excel Copilot: Create Worksheets from Prompts with Ease

Posted by Chris Menard on 05/11/2025

5 Essential Excel Tips Everyone Should Know

Posted on 11/27/2024

Excel Focus Cell: Enhancing Active Cell Visibility and Navigation

Posted by Chris Menard on 10/20/2024

Excel 7 Easy Tips Everyone Should Know

Posted by Chris Menard on 08/11/2024

Copilot In Excel: NEW Feature Enables Copilot Use Without a Table

Posted by Chris Menard on 08/10/2024

Discover Excel New Features: A Guide to 6 Exciting Updates in Excel for the Web

Posted by Chris Menard on 07/25/2024

Essential Excel Keyboard Shortcuts for Selecting Data

Posted by Chris Menard on 06/26/2024

Oct 28, 2024 - I'll be Speaking at the Administrative Professionals Conference on Excel Copilot: Data Analysis Simplified

Posted on 04/29/2024

Chris Menard

Chris Menard is a Microsoft Trainer (MCT) and works as a full-time Trainer at BakerHostetler - one of the largest law firms in the US. Chris runs a YouTube channel with 900+ technology videos that cover various tools such as Excel, Word, Zoom, Teams, Gmail, Copilot, Google Calendar, and Outlook. To date, the channel has helped over 20 million viewers. Menard also does 2 to 3 public speaking events yearly, presenting at the Administrative Professional Conference (APC), the EA Ignite 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.