We can always combine the formulas to achieve anything we want if there is no direct path to achieve something in Excel.
Manipulating dates is not an exemption from this. In the example below, we will show how to use multiple formulas to display dates in uppercase.
Display the Date in Uppercase in Excel
For our example, we will insert the long date in cell A2:
If we want to make this text in uppercase, we will combine formulas UPPER and DATE. The formula that we will insert in cell B2 will be:
|
1 |
=UPPER(TEXT(A2, "dddd-mmm-yyyy")) |
Formula UPPER only needs a specific text. Our text will be cell A2, but it will be formatted to show the full day, month, and year.
Formula UPPER makes all the text in desired cell or range uppercase. This is the result we will end up with:
