Date Question

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

[daddylonglegs]

Try this formula

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

or

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

and format cell as "mmmm"

[Dave Peterson]

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

[Bob Phillips]

How about just formatting column B as

d mmmm yyyy

--

HTH

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


"John" <[email protected]> wrote in message
news:[email protected]...
> 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?

[Peo Sjoblom]

=TEXT(B6,"mmmm")



--
Regards,

Peo Sjoblom

Portland, Oregon




"John" <[email protected]> wrote in message
news:[email protected]...
>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?