Comparing a formated result with a harcoded value

[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

 

[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")

 

[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?

 

[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")