Geoff Taylor
Active Member
- Joined
- Dec 11, 2006
- Messages
- 257
Hi,
In Cell F16 I have a date, 01/08/2010 - (August 1st, 2010)
The formula MONTH(F16) returns the number 8, which is as it should.
The formula TEXT(MONTH(F16),"Mmm") returns "Jan", which is obviously incorrect. It should say "Aug"
What am I doing wrong?
I'm using Excel 2007
In Cell F16 I have a date, 01/08/2010 - (August 1st, 2010)
The formula MONTH(F16) returns the number 8, which is as it should.
The formula TEXT(MONTH(F16),"Mmm") returns "Jan", which is obviously incorrect. It should say "Aug"
What am I doing wrong?
I'm using Excel 2007