Text

[DDH]

IFERROR(IF(MONTH(A32)<>MONTH(A33),TEXT(A32,"m"),""),TEXT(A32,"M))

This formula will return "11" (numerical month)

I am trying to have it produce "N" a text month,
I know "MMM" will return "NOV"

I thought that logicaly this should work but it does
not.
Thank you for your help.


IFERROR(IF(MONTH(A32)<>MONTH(A33),(A32,"m"),""),(A32,"M))

 

[niceguy_jay]

Try this...

=choose(iferror(if(month(a32)<>month(a33),month(a32),month(a32)),text(a32,"m")),"jan","feb","mar","apr","may","jun","jul","aug","sep","oct","nov","dec")

 

[DDH]

niceguy_jay - Thank you for your help.
I change it to
CHOOSE(IFERROR(IF(MONTH(A3)<>MONTH(A4),MONTH(A3),MONTH(A3)),TEXT(A3,"m")),"J","F","M","A","M","J","J","A","S","O","N","D")

but the ISERROR is gone and how would it handle the "J" for June and
"J" for July.

 

[niceguy_jay]

it is working fine...your modified formula...I am getting J for June and J for July as well..
what error you are getting ??

 

[DDH]

niceguy_jay - Thank you for your help

IFERROR(IF(MONTH(A32)<>MONTH(A33),TEXT(A32,"m"),""),TEXT(A32,"M))

The )'"") is missing

I tried to add it, but it gives me an error.

choose(iferror(if(month(a32)<>month(a33),month(a32),month(a32)),text(a32,"m"),""),"jan","feb","mar","apr","may","jun","jul","aug","sep","oct","nov","dec")

 

[SuperFerret]

How do you differentiate between:
January (J) June (J) and July (J) and also March (M) and May (M) ?

 

[DDH]

SuperFerret - I agree that is my question along with the other one I asked.
I don't think Excel could tell the difference between Jun and Jul.

I just thought I would ask to see if it was possible.
Thank you for your help.

 

[niceguy_jay]

I have modified the formula to accommodate your requirement...can you check this..

=IFERROR(CHOOSE(IFERROR(IF(MONTH(A3)<>MONTH(A4),MONTH(A3),""),TEXT(A3,"m")),"J","F","M","A","M","J","J","A","S","O","N","D"),"")

 

[DDH]

niceguy_jay - Thank you for your help.

It works perfect.
I was looking at the normal text formula.

10/15/11 to return "October" Formula -- TEXT(O34,"mmmm")
To return the day --"Wednesday" Formula --- TEXT(O34,"dddd")

I was just trying to see if I could get it to do the same thing
and return just "O" or "W" by only having one "M" and one "D".
It did not work.
I would have thought it would have worked the same as in
the other formula.
Thanks again for your help.