Excell Upper

[kvandalia]

Morning. I have a cell with "=DATE($K$1,$K$2,1)" to pull the month and year out of cells K1 & K2. The result is "January 2019". I would like to have the result be "JANUARY 2019". Is there a way to do this in the same cell by imbedding the formulas? I've tried several solutions I thought would work and always seem to get some kind of error message. Thanks in advance!

[#2]

Try this formula:
=UPPER(TEXT(DATE(K1,K2,1),”mmmm yyyy”))

[#3]

That did it! Explains one of the error messages I was getting as well. Thank you Twifoo!

[#4]

I’m glad to hear that!