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

preview_player
Показать описание
The MONTH function in Excel allows you to extract the month from the date. In this video, 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.

In this Excel Short tutorial, I aim to provide a complete quick reference of all the Excel formulas or functions, with simple to follow examples, the complete formula, and use cases. Make sure to subscribe for more videos like these almost every day.

Here is the full list of EXCEL MINUTE videos:

And make sure you subscribe to my channel!

-- EQUIPMENT USED ---------------------------------

-- SOFTWARE USED ---------------------------------

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!

#excel #monthfunction #excelbeginners
Рекомендации по теме
Комментарии
Автор

Thank you for posting this helpful video!

jhors
Автор

I spent over 30 minutes trying so many different methods from google - This one worked! Thank

PATRICIAGIESE-ddzf
Автор

Thanks so much! I was struggling with this and some long winded functions, and I didn't think it could be so easy; but it was!

jackhummel
Автор

Another good one Chris! I use this function all the time combined with the TEXT function to get my months in letters.

mrmusicloverable
Автор

Thanks so much easy and simple saved me lots of time!

edwarddizengoff
Автор

I hope this isn't Chris' blood! (nice shirt).

lemaywebdesign
Автор

how to do: July (07) ---> 07, month function 07-->7

silkvietnam