Forum Discussion

kvandalia's avatar
kvandalia
Copper Contributor
Feb 27, 2019

Excell Upper

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!

3 Replies

  • kvandalia's avatar
    kvandalia
    Copper Contributor
    That did it! Explains one of the error messages I was getting as well. Thank you Twifoo!
  • Twifoo's avatar
    Twifoo
    Silver Contributor
    Try this formula:
    =UPPER(TEXT(DATE(K1,K2,1),”mmmm yyyy”))