View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Russell Dawson[_2_] Russell Dawson[_2_] is offline
external usenet poster
 
Posts: 181
Default changin date dd/mm/yy into Month

Input date as you have.
Format cells
Custom format
mmmm
--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"Jo" wrote:

I am trying to summarise dates from 01/04/09 to April. Can any body help.
I have tried = month(cell) , but it comes up with a value . Any ideas?