Help needed to convert text into all UPPER CASE

Originally Posted by FDibbins

Try this. It is based on A1...
=UPPER(TEXT(A1+6,"dddd, mmm, dd, yyyy"))

Note that this is now no longer a value or valid date, it is text...and as such, can no longer be used directly in any calcs.

Brilliant! Thanks very much!