if/countif for 12 different arguments

[Studebaker]

I'm trying to write an if/countif function for the following situation:

if column L has the 2nd and 3rd #s that are "01" then write "01" in column M
if column L has the 2nd and 3rd #s that are "02" then write "02" in column
M, etc.
all the way to 12. (01, 02,....12 standing for the days of the month.)

I wrote:
if(countif(L3,"?01*"),"01",if(countif(L3,"?02*"),"02",if(countif(L3,"?03*"),"03", etc.
but it's wrong b/c I don't know how to write a long if function.

Can someone help?

 

[Elkar]

So, you basically just want to return the 2nd and 3rd characters from the
string in column L? Try this:

=MID(L3,2,2)

HTH,
Elkar

 

[T. Valko]

Are these dates you're working with?

What's in L3? You'll need to show us some examples.

 

[Gabriella777_2]

That is so Cool!
And it works with letter's as well!
What are some of the boundaries of this equation?

 

[Studebaker]

That's exactly what I needed. Thank you so much!

So, you basically just want to return the 2nd and 3rd characters from the
string in column L? Try this:

=MID(L3,2,2)

HTH,
Elkar