Date formula question

T

totallyintheblue

if i put the formula =TODAY() and set the cell format to Date and the
function to mmmm i get out february and cell value..all well and
fine..but i want February..with a capital F..so...how do resolve this
nitpicking question

TIA
and thx for all other tips i have swooped up here
 
B

Bob Umlas

It should be returning February with a capital F anyway. But if not, you can
use =PROPER(TEXT(TODAY(),"mmmm"))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display weeks from a Milestone 0
If Formula and Dates 4
Use TODAY() function as the criteria in a SUMIF formula 1
Vlookup? 1
Formula for selecting a Leap Year. 7
Formula to count based on multiple criteria fields w/duplicates 5
Referecing Worksheet names that are dates in a formula 2
Show value from one cell in another cell if today falls between a date range 5

Top