Date Question

J

John

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?
 
D

daddylonglegs

Try this formula

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

or

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

and format cell as "mmmm"
 
D

Dave Peterson

Maybe you could use:

=text(B6,"mmmm")

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

Bob Phillips

How about just formatting column B as

d mmmm yyyy

--

HTH

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