Here's an easy one...MONTH

[DanOfEarth]

Real quick,

My brain's not working.

I forgot the simple worksheet function to copy/paste only the MONTH (in TEXT) from one cell to another. ie.

A1: 12/12/2009 B1: December

I thought it was : B1 "=MONTH(A1)"

or.....B1 "=DATE(MONTH(A1))

Guess not.

[mbarron]

=Text("A1","mmmm")

[mbarron]

Or you could use =A1 and then use a custom format on the cell of mmmm.

[DanOfEarth]

Ah....I tried the Text function....didn't work. Actually, the second one worked....just did a =Al and did a custom format.

LOL. No wonder I missed it.

Thanks guys!

[mbarron]

:omg2:
The first one should be:
=text(A1,"mmmm")

[Aussiebear]

@ mbarron :rotlaugh:.... It can happen to anyone.