Hi
You received the answer to your question by "Teethless mama.
Did you try it?? if its not working, tell us what its doing.
HTH
John
"Centrol" wrote in message
...
need the formula to return 'Aug' and not '8'




"Ashish Mathur" wrote in message
...
Hi,

you can also use =month(cell_ref)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Christine" wrote in message
...
what is the formula for returning the month (eg Aug) of a date?