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


One thought on “MS EXCEL MONTH function madness

Leave a Reply

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

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

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s