Get instant live expert help on I need help with excel month number

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I have one number 181101 - It signifies 18 as YEAR, 11 is the Month (November) and 01 is the batch Number...Excel is extracting Year and Month, as digits, though my requirement is to extract Year as 2018 and Month as Nov. Please help
Solved by I. Y. in 28 mins
I need a formula to change the month number in cells E2:E38342 into the month name, instead of just the month number
Solved by V. U. in 28 mins
I have one number 181101 - It signifies 18 as YEAR, 11 as MONTH as 01 as BATCH NUMBER....I am seeking answer to this puzzle as and when I enter these numbers (181102, 181103 et al), Excel automatically picks up Year and Month from this to another column.
Solved by D. A. in 13 mins
I need assistance populating charges for each phone number, each month
Solved by T. J. in 26 mins
i need a age calculator that return number of years month and days
Solved by Z. A. in 20 mins