Month
 

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

Month
 

=TEXT(A1,"mmm")

"Christine" wrote:

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

Month
 

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?

Month
 

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?

Month
 

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?

Month
 

Hi,

Try this

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

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"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?

Month
 

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

Ashish Mathur wrote:
Hi,

Try this

text(month(cell_ref),"mmmm")

"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?

Month
 

Thanks for the correction

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
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

Ashish Mathur wrote:
Hi,

Try this

text(month(cell_ref),"mmmm")

"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?