How to get the month from a date in Excel
In this video, I'll show you 3 ways to get the month from a date in Excel.
🔔 Subscribe and click the bell to stay up-to-date on the channel.
/ @planillaexcel
CHAPTERS
0:00 - Introduction to date processing in Excel
0:20 - Why extract the month from a date?
0:39 - Method 1: MONTH Function
1:12 - Advantages and disadvantages of Method 1
1:19 - Method 2: TEXT Function
1:57 - Different month formats with TEXT
2:13 - Disadvantage: TEXT returns a text format
2:23 - Method 3: Custom Format
2:58 - Applying a month-only format from the menu
3:14 - Advantages and disadvantages of custom formatting
3:26 - Conclusion: Which method should you choose?
RESOURCES:
✅How to convert text to dates: • Como convertir texto en fecha en Excel
👪 Follow us on our social networks:
► Facebook / planillaexcelcom
► Twitter / planillaexcel
► Instagram / planilla.excel