Formula help needed.. dates to number

[Matador1]

I have a column that is closing date for deals, example 30-Oct-09. I need a column beside it that converts that to either a number for the month (10 for October) or simply enters the actual Month. I want to be able to sort all deals by month instead of yr.

 

[oldbrewer]

if that date were in A1 then in B1 put =text(A1,"mmm")

 

[Rick Rothstein]

if that date were in A1 then in B1 put =text(A1,"mmm")

Or if you want the month number...

=MONTH(A1)

 

[Kevin Neufeld]

=month(cell#) will return the number of month
or
=CHOOSE(MONTH(E2), "Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec") will give you the name of the month, which I prefer.

 

[arthurbr]

Eventually try a Pivot Table and group dates by months ( assuming you have real dates not text looking like dates)

 

[Rick Rothstein]

o00r
=CHOOSE(MONTH(E2), "Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec") will give you the name of the month, which I prefer.

You like that formula better than the one oldbrewer gave in Message #2 ?

 

[Kevin Neufeld]

actually no, now that I see it, it wasn't up when I posted. Thanks