I am creating a worksheet that will last specific dates in column B. In
Colum C I want it to just list the month. There is going to be about 20-100
lines for each day, so i guess i want to use a formula that says if b6 =
1/15/2006 then in column c6 put January, etc. Is that possible?

Try this formula

=IF(B1<"",TEXT(MONTH(B1),"mmmm"),"")

or

=IF(B1<"",B1,"")

and format cell as "mmmm"


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=501495

Maybe you could use:

=text(B6,"mmmm")

or just:
=b6
but give it custom format of mmmm



John wrote:

I am creating a worksheet that will last specific dates in column B. In
Colum C I want it to just list the month. There is going to be about 20-100
lines for each day, so i guess i want to use a formula that says if b6 =
1/15/2006 then in column c6 put January, etc. Is that possible?

--

Dave Peterson

How about just formatting column B as

d mmmm yyyy

--

HTH

RP
(remove nothere from the email address if mailing direct)


"John" wrote in message
...
I am creating a worksheet that will last specific dates in column B. In
Colum C I want it to just list the month. There is going to be about
20-100
lines for each day, so i guess i want to use a formula that says if b6 =
1/15/2006 then in column c6 put January, etc. Is that possible?

=TEXT(B6,"mmmm")



--
Regards,

Peo Sjoblom

Portland, Oregon




"John" wrote in message
...
I am creating a worksheet that will last specific dates in column B. In
Colum C I want it to just list the month. There is going to be about
20-100
lines for each day, so i guess i want to use a formula that says if b6 =
1/15/2006 then in column c6 put January, etc. Is that possible?