Welcome! Register Now to Unlock Exclusive Excel TutorialsGet Started
- Exclusive Playlists
- Downloadable Videos
- No Ads!
- Exclusive Templates
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
02. Get the Month Name from the date
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.