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...
excel
Formulas and Functions
Twifoo's avatar
Twifoo
Silver Contributor
Feb 27, 2019
Try this formula:
=UPPER(TEXT(DATE(K1,K2,1),”mmmm yyyy”))