looking to combine if and mid function---i think

[awest181]

Three cells lets say A1, B1, and C1.

A1=2012
B1=JAN-1-2012
C1=JAN

Currently i have it set up to fill in C1 automatically with JAN by using =MID(B1,1,3)
What i am hoping to acheive is only fill in C1 with JAN if year reads 2012 by getting from A1, if A1 reads 2013 and B1 reads JAN-1-2012 then C1 is blank. What is formula to achieve this??

[Miraun]

Are these formatted as dates, or just strings that you're using as an example?

[djapigo]

Try this in C1:
=IF(A1=2012,"JAN","")

[Ace_XL]

=IF(A1=2012,left(B1,3),"")

[awest181]

Perhaps i didnt explain enough A1 will read 2012, B1 will read any date that is entered manually. C1 will only count first three, so JAN, FEB, MAR, ETC. Now if i change A1 to 2013 all C1's will be blank.

[djapigo]

Hi awest, can you answer Miraun's question... thanks...

[awest181]

Yes formated as a date

[djapigo]

Try this...

=IF(A1=2012,CHOOSE(MONTH(B1),"JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC"),"")

[martindwilson]

if you are extracting jan by

"Currently i have it set up to fill in C1 automatically with JAN by using =MID(B1,1,3)"

then that cell is not a real date but text
otherwise it would return 409 the first 3 digits of 1/1/2012 date code
so it must be text then
=IF(--RIGHT(b1,4)=--a1,LEFT(b1,3),"")

[awest181]

still not working, please help. I have included attachment. This spreadshee is used as a counter on another spreadsheet. It counts the JAN, FEB, ETC from the L cloumn. But when year changes we have to go in an manually look for the 2012 entries and make column blank so it is not counted. What i would like to do is just change the year in cell A2 to 2013 and have all entries in column L go blank--so they are not counted on corosponding spreadsheet.

[martindwilson]

in l2
=IF(M2="","",IF(--RIGHT(M2,4)=--$A$2,LEFT(M2,3),""))

[awest181]

success---thanks martin