I'm looking for a formula that will look at a date in a column and
return just the month.

For example:

Column A Row 1 is 6/10/2005

I am looking for a formula that will look at that date and return
"June" (or whatever month is represented in the date) in Column B Row 1
for the same record.

Any ideas?

PZan


--
PokerZan
------------------------------------------------------------------------
PokerZan's Profile: http://www.excelforum.com/member.php...o&userid=23480
View this thread: http://www.excelforum.com/showthread...hreadid=378119

=TEXT(A1,"mmmm")

Does that help?

Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=378119

Like a charm, thanks!


--
PokerZan
------------------------------------------------------------------------
PokerZan's Profile: http://www.excelforum.com/member.php...o&userid=23480
View this thread: http://www.excelforum.com/showthread...hreadid=378119

You don't even need that formula, you can just link

=A1

then custom format the cell mmmm


Regards,

Peo Sjoblom

"PokerZan" wrote:


Like a charm, thanks!


--
PokerZan
------------------------------------------------------------------------
PokerZan's Profile: http://www.excelforum.com/member.php...o&userid=23480
View this thread: http://www.excelforum.com/showthread...hreadid=378119