1

Currently, I am using the EDATE function in cell A5.

It is displaying the date as "February".

I want this "February" to be displayed as "FEBRUARY". (simple change to upper case)

How can I do this whilst keeping the formula currently in cell A5?

Cell A5 formula : =EDATE(A4,1)

Insider
  • 95
  • 12
  • I can only think of doing 12 separate condition formats at the moment - not very practical. – Tom Sharpe Mar 31 '21 at 10:42
  • If you need to use the date in a calculation elsewhere, it would be easier to do that calculation somewhere else and then use a formatted text version in A5. – Rory Mar 31 '21 at 11:01
  • 1
    Far stretched, but you can install an all-caps font like "Bebas Neue" and use that. – JvdV Mar 31 '21 at 11:02

4 Answers4

1

Use a font which is all capitals e.g.Perpertua Titling MT

enter image description here

Otherwise conditional format

dd \F\E\B\R\U\A\R\Y yyyy

with custom formula

=month(C1)=2

and so on for all 12 months.

Tom Sharpe
  • 30,727
  • 5
  • 24
  • 37
1

If your cell content doesn't need to be a numeric date. Means you don't calculate with this cell and it is just for displaying purpose, then use the following formula

=UPPER(TEXT(EDATE(A4,1),"MMMM"))
Pᴇʜ
  • 56,719
  • 10
  • 49
  • 73
1
=PROPER(TEXT(EDATE(A4,1),"MMMM"))
drgs
  • 375
  • 2
  • 8
1

=UPPER(TEXT(EDATE(A4,1),"dd MMMM yyyy"))

This works quite well when using other date functions like e.g. EOMONTH

Mike Simmonds
  • 11
  • 2