Welcome! Lets start your excel journey..

Welcome! Register Now to Unlock Exclusive Excel Tutorials

Get Started
  • Exclusive Playlists
  • Downloadable Videos
  • No Ads!
  • Exclusive Templates

How to get Month Name and number in 2 Easy Steps

Admin
Duration: 4:46
Submitted: 1 month ago
Views: 72

Comments (0)

Link to this video:

Description: In this Excel formula, we will get the month name and number using 3 different functions namely, MONTH, TEXT, DATEVALUE Functions. Watch the video above and browse through the table of contents below to find the timeline.

We will use the following formula

01. Get the Month Number from the date

=MONTH(

02. Get the Month Name from the date

=TEXT(

03. Get Month Number from month name

=TEXT( [In this we multiply by *28 to get the exact month number]

04. Get Month name from number.

=MONTH(DATE VALUE(