Month

[Christine]

what is the formula for returning the month (eg Aug) of a date?

 

[Teethless mama]

=TEXT(A1,"mmm")

 

[Ashish Mathur]

Hi,

you can also use =month(cell_ref)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[Centrol]

need the formula to return 'Aug' and not '8'

Hi,

you can also use =month(cell_ref)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[John]

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

 

[Ashish Mathur]

Hi,

Try this

text(month(cell_ref),"mmmm")
--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[Ashish Mathur]

Thanks for the correction

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

I'm reluctant to argue with an MVP, Ashish, but I think that your formula
would invariably return January.

I think you may have intended to say
=text(cell_ref,"mmm")
[No MONTH function, and only 3 m characters.]
--
David Biddulph

Hi,

Try this

text(month(cell_ref),"mmmm")