Excel Forum
Similar Content
Convert Month Name to Number and Vice Versa in Excel
Tutorial: How to convert a month's name, such as January, into a number using a formula in Excel; al...
Reference Other Excel Files with Formulas and Functions
Tutorial: In Excel you can use formulas and functions to reference data that is stored in another Ex...
Error Values in Excel - Full Explanation
Tutorial: Here, I'll teach you what the errors in Excel mean.  There are many errors that you can ...

Slaying Excel Dragon Book Is Out In Print! Also: Cool Excel MONTH Function Trick.

Finally!!! The Slaying Excel Dragon book is out in print! You can get it at your favorite book seller!
Book Title: Slaying Excel Dragons: A Beginners Guide to Conquering Excel's Frustrations and Making Excel Fun
ISBN: 9781615470006
In this video see: How to take Month Criteria as "Feb" or "February" and convert it to a 2 so that the MONTH function can understand the criteria. The trick: Ampersand a 1 to the front of the word!!! Like:
A1 = FEB, then use formula: =MONTH(1&A1), which will equal 2
Amazing trick!!

Got a Question? Ask it Here in the Forum.