C
Christine
what is the formula for returning the month (eg Aug) of a date?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
Teethless mama
=TEXT(A1,"mmm")
A
Ashish Mathur
Hi,
you can also use =month(cell_ref)
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
you can also use =month(cell_ref)
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
C
Centrol
need the formula to return 'Aug' and not '8'
Ashish Mathur said:Hi,
you can also use =month(cell_ref)
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
J
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
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
A
Ashish Mathur
Hi,
Try this
text(month(cell_ref),"mmmm")
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
Try this
text(month(cell_ref),"mmmm")
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
A
Ashish Mathur
Thanks for the correction
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
David Biddulph said: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 said:Hi,
Try this
text(month(cell_ref),"mmmm")