View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
SSJ SSJ is offline
external usenet poster
 
Posts: 58
Default EXTRACT MONTH FROM DATE

Hello,

I am using the following formula to extract month from the date:

=month(a1)

The result is 1

What I wan to see is Jan instead of 1.

Also what do I need to do if I want the result as Jan-08

Thanks
SJ