Main Profile

At A Glance

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!!
Length: 05:57

Contact

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

Want more info about Slaying Excel Dragon Book Is Out In Print! Also: Cool Excel MONTH Function Trick.? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question