Just the month

[David]

I have a column where dates are entered and I need the
adjacent column to shown what the months of those dates
are. For instance

A1 is 03/15/04
B2 needs to be 03 or March

Can anyone help me out with this? Thanksin advance.

David

 

[Jason Morin]

=TEXT(A1,"mmmm")

HTH
Jason
Atlanta, GA

 

[Ron Rosenfeld]

I have a column where dates are entered and I need the
adjacent column to shown what the months of those dates
are. For instance

A1 is 03/15/04
B2 needs to be 03 or March

Can anyone help me out with this? Thanksin advance.

David

In B2 put the formula =A1 and custom format as "mm" or "mmmm"

Or use the formula =TEXT(A1,"mm") for 03 or
=TEXT(A1,"mmmm") for March.

Using the TEXT formula, the cell will contain text.

Note that your specifications call for the date and the Month to be in
different rows (A1..B2)


--ron

 

[Dave R.]

you can also try MONTH(A1)