If formula with 12 conditions

Thanks for the feedback! Glad to help.

--
Andy.


"tkacoo" <tkacoo@discussions.microsoft.com> wrote in message
news:B4CB4EC2-60AC-4318-BE2C-CA2602EC0A20@microsoft.com...
> Thank you... you are awesome!!!!
> used =MONTH(A2)
> Worked perfect!!!
>
> "Andy B" wrote:
>
>> Hi
>> You could try something like
>> =TEXT(A2,"mm")
>> in B3.
>> Or simply
>> =MONTH(A2)
>>
>> --
>> Andy.
>>
>>
>> "tkacoo" <tkacoo@discussions.microsoft.com> wrote in message
>> news:4BF32B13-54EF-4E80-ADC4-9B752A31CCC1@microsoft.com...
>> >I have a date column and I want another column to sort only by the month
>> >of
>> > the date column. So I want column B to look at column A and only read
>> > the
>> > month - then translate it to a number.
>> > If the first 2 numbers in (a2=01 then b3=1 , or a2=02 then b3=2, or
>> > a2=03
>> > then b3=3.... ect)
>> > Can this be done?
>> >
>>
>>
>>

Hope your still here... I have one more condition...
If the A2 is blank, b3 should be blank ...

"Andy B" wrote:

> Thanks for the feedback! Glad to help.
>
> --
> Andy.
>
>
> "tkacoo" <tkacoo@discussions.microsoft.com> wrote in message
> news:B4CB4EC2-60AC-4318-BE2C-CA2602EC0A20@microsoft.com...
> > Thank you... you are awesome!!!!
> > used =MONTH(A2)
> > Worked perfect!!!
> >
> > "Andy B" wrote:
> >
> >> Hi
> >> You could try something like
> >> =TEXT(A2,"mm")
> >> in B3.
> >> Or simply
> >> =MONTH(A2)
> >>
> >> --
> >> Andy.
> >>
> >>
> >> "tkacoo" <tkacoo@discussions.microsoft.com> wrote in message
> >> news:4BF32B13-54EF-4E80-ADC4-9B752A31CCC1@microsoft.com...
> >> >I have a date column and I want another column to sort only by the month
> >> >of
> >> > the date column. So I want column B to look at column A and only read
> >> > the
> >> > month - then translate it to a number.
> >> > If the first 2 numbers in (a2=01 then b3=1 , or a2=02 then b3=2, or
> >> > a2=03
> >> > then b3=3.... ect)
> >> > Can this be done?
> >> >
> >>
> >>
> >>
>
>
>

Hi
Try this:
=IF(A2<>0,MONTH(A2),"")

--
Andy.


"tkacoo" <tkacoo@discussions.microsoft.com> wrote in message
news:973E15BA-A53F-49BC-821E-04F1B08C5656@microsoft.com...
> Hope your still here... I have one more condition...
> If the A2 is blank, b3 should be blank ...
>
> "Andy B" wrote:
>
>> Thanks for the feedback! Glad to help.
>>
>> --
>> Andy.
>>
>>
>> "tkacoo" <tkacoo@discussions.microsoft.com> wrote in message
>> news:B4CB4EC2-60AC-4318-BE2C-CA2602EC0A20@microsoft.com...
>> > Thank you... you are awesome!!!!
>> > used =MONTH(A2)
>> > Worked perfect!!!
>> >
>> > "Andy B" wrote:
>> >
>> >> Hi
>> >> You could try something like
>> >> =TEXT(A2,"mm")
>> >> in B3.
>> >> Or simply
>> >> =MONTH(A2)
>> >>
>> >> --
>> >> Andy.
>> >>
>> >>
>> >> "tkacoo" <tkacoo@discussions.microsoft.com> wrote in message
>> >> news:4BF32B13-54EF-4E80-ADC4-9B752A31CCC1@microsoft.com...
>> >> >I have a date column and I want another column to sort only by the
>> >> >month
>> >> >of
>> >> > the date column. So I want column B to look at column A and only
>> >> > read
>> >> > the
>> >> > month - then translate it to a number.
>> >> > If the first 2 numbers in (a2=01 then b3=1 , or a2=02 then b3=2, or
>> >> > a2=03
>> >> > then b3=3.... ect)
>> >> > Can this be done?
>> >> >
>> >>
>> >>
>> >>
>>
>>
>>