Thread: Date Question
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Date Question

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