Comparing a formated result with a harcoded value

A

a94andwi

Hello.

I have a cell containing the numeric value. I use cell formatting to
present the numeric value as which month it is. The formats value is
"april"

In another cell I have the hardcoded text value "april".

How do I compare these two cells and find out if they are the same?

/Anders
 
J

JE McGimpsey

One way:

Assume A1 is the cell containing the numeric value and B1 is the cell
with the text:

=IF(TEXT(A1,"mmmm")=B1,"same","different")
 
A

a94andwi

thank you. It worked great.

If I have this formula =TEXT(TODAY(); "MMMM") and want the next cell
to contain the next month, how do I do that? I guess I should add
something in the formula but I don't know what.

Can you help?
 
J

JE McGimpsey

In general, you'll get better help if you start a new thread for a new
question - when people see that an answer has already been given, they
often don't read the reply to see if there's a follow-up.

one way:

=TEXT(DATE(YEAR(TODAY()),MONTH(TODAY())+1,1),"mmmm")
 
Top