Thread
:
EXTRACT MONTH FROM DATE
View Single Post
#
1
Posted to microsoft.public.excel.newusers
SSJ
external usenet poster
Posts: 58
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
Reply With Quote
SSJ
View Public Profile
Find all posts by SSJ