Comparing a formated result with a harcoded value

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

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

In article <a94andwi.2678ha_1144925400.5134@excelforum-nospam.com>,
a94andwi <a94andwi.2678ha_1144925400.5134@excelforum-nospam.com>
wrote:

> 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

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?

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


In article <a94andwi.267cvm_1144931100.4053@excelforum-nospam.com>,
a94andwi <a94andwi.267cvm_1144931100.4053@excelforum-nospam.com>
wrote:

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