MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Uppercase Today() function


Posted by Beginner Bob on November 02, 2000 10:36 AM

I have a worksheet template which is all in uppercase letters. I have a cell which contains "=TODAY()". I would like to have this date read "NOVEMBER 2, 2000", instead of "November 2, 2000" or "11/2/00". I have changed the format of the cell to the correct format. I have also tried "=UPPER(TODAY())", and this returns the date code. Is there a way I can work around this to capitalize the month in a today function without using additional cells (like B1=A1,copy, paste special etc.) Thanks for any help.


Posted by Tim Francis-Wright on November 02, 2000 11:59 AM

The problem is that TODAY() returns a number,
even if you've formatted the number to look like
November 2, 2000. You can use the TEXT function
to work around this:-

=UPPER(TEXT(TODAY(),"mmmm d, yyyy"))

check out the help file for "custom number, date,
and time format codes" for more information about
the formats to use with the TEXT function.

HTH

Posted by Veronica P. on November 02, 2000 12:58 PM

Bob try this:

=UPPER(TEXT(TODAY(),"MMMM D, YYYY"))

Posted by Bob on November 02, 2000 5:09 PM

Those both work great, thanks Veronica and Tim.

But I bet you guys knew that huh :-)