Upper Case Date Formula

T

titan

New Member
Joined
Jan 29, 2005
Messages
1
I am using a formula to return the date in cell B1: =NOW()+28. This returns February 2005. Can I add to this formula or format the cell to return: FEBRUARY 2005? I would like the month to show as all upper case. Thank You.
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
Sort by date Sort by votes
titan said:
I am using a formula to return the date in cell B1: =NOW()+28. This returns February 2005. Can I add to this formula or format the cell to return: FEBRUARY 2005? I would like the month to show as all upper case. Thank You.
Click to expand...

=UPPER(TEXT(TODAY()+28,"mmmm yyyy"))
 
Upvote 0
You must log in or register to reply here.

Similar threads

SimonHughes
  • Solved
Always upper case
2
Replies
16
Views
189
Joe4
Joe4
N
  • Solved
VBA code for deleting rows based on number of days in a month
2
Replies
11
Views
391
nitiona
N
V
  • Solved
Search, index, filter formula
Replies
3
Views
57
Fluff
Fluff
J
  • Question
Formula Needed - Create a Multiplier w/o helper columns
Replies
2
Views
112
Fluff
Fluff
0 Agios
  • Question
Inserting formula in range
Replies
2
Views
110
0 Agios
0 Agios

Forum statistics

Threads
1,203,437
Messages
6,055,375
Members
444,781
Latest member
rishivar

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top