MS EXCEL MONTH function madness


I guess we are all familiar with the MONTH function in Excel. If you give it a date it will return the month number. So far so good. Now here’s the strange thing…

If for example cell A1 contains a name of a month (let’s say November) and you want to get the month number out of it. Now some might say VLOOKUP and they would be spot on but here what you can also do. You can say =MONTH(“1″&A1) and you get 11. Wow!


Here’s why this works. 1November is recognized as a date so the MONTH function still recieves what it was expecting, but nobody really knows this 🙂 If anybody has more of this kind of madness in Excel to report, I would be very greatfull

Advertisements

One thought on “MS EXCEL MONTH function madness

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s