I am beating my head on the wall! ;) (1 Viewer)

[Daxton A.]

I am trying to find the quick way for texting the Month off this formula:

=MONTH(NOW())

but the value that gets returned is a Number and it seems like there is an easier way than nested if statements to get what im wanting. Now, I would like to keep this out of VBA perty please.

Ty!
Daxton

 

[Isskint]

If it is to display the month name, then format the cell as "mmmm" and just have =NOW()

If you are returning it for a formula then adjust the formula to work with numbers.

Other than that you will need VBA OR nested IFs

 

[boblarson]

Instead of Now, use =TODAY() for just the date. No need to worry about the time if you are only using the month. And then as mentioned set the cell format to be

mmmm

under the custom format area of the FORMAT > CELLS

 

[unknown27]

If you're looking for the actual month text to be the value of the cell use;

=TEXT(TODAY(),"mmmm")

So for today, the value of the cell would then be the text; "August".