Just the month

  • Thread starter Thread starter David
  • Start date Start date
D

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
 
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
Click to expand...

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
 
Back
Top