|
|
Featured Tutorial
Featured Macro
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!!
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!!