Custom date cell format capital letters

[Viics]

Hi!

I need change the cell format for date, I want the text in capital letters, all of them, only I can chenge the first letter.

I used this format: [$-380a]mmmm;@ but for the days of the week doesn't work, even doesn't change the first letter as in month

I cant use the formula =MAYUSC() because the cell where is the month and days makes reference a other formula

Could you help me please?

[#2]

Try =UPPER(TEXT(NOW(),"dddd, mmmm dd,yyyy"))

[#3]

@Viics 

There is no such custom number format which forces to return month names in uppercase. If within one cell, i.e. without MAYUSC() / UPPERCASE(), that's with VBA programming.