Excel Forum
Similar Content
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...
Round Numbers Up or Down in Excel
Tutorial: How to round a number up or down and also to a specified number of decimal places in Excel...



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.