Thread: Date Question
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom
 
Posts: n/a
Default Date Question

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