Solved If the date is 002/01/17, how can I make February show up?

Microsoft Outlook 2013 32/64-bit (mail m...
March 3, 2017 at 11:39:57
Specs: Windows 64
the second part of this is if it's not February, I want it to say "Other". This is failing right now but it seems it should work....

=IF((TEXT(a2, "mmmm"),"February"),"Other")

I hope someone is going to say I'm just missing a commar or something....and later, I will want to add other months to this, too. Any ideas?


See More: If the date is 002/01/17, how can I make February show up?

Report •

#1
March 3, 2017 at 12:00:43
✔ Best Answer
I believe that the following formula should work, assuming that A2 contains a date.

Your subject line shows 002/01/17, which could be a problem.

If A2 contains 02/01/17, then this formula should work:

=IF(MONTH(A2) = 2, "February","Other")

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

message edited by DerbyDad03


Report •

#2
March 3, 2017 at 12:09:52
Thank you very much, DerbyDad! That's a perfect and simple solution.

Report •

#3
March 3, 2017 at 12:16:51
I'm glad I could help. If you wanted to use a formula similar to what you tried, it would have to look like this:

=IF(TEXT(A2,"mmmm")="February","February","Other")

In your version you did not really have a logical_text for the IF because you were not comparing TEXT(A2,"mmmm") to anything.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question