Hi Roger,

Yes, I know that the Month() of a May date will give =5, which
displayed as "mmm" will give Jan, but that didn't stop my first post.
However I had forgotten the Text option when I tried to beak the 'mmm'
free of a date format in the Lookup, thanks for that, and lets hope
that gireesh gains something from this too.


Roger Govier Wrote:[color=blue]
Hi Bryan

Formatting a cell as mmm will display the Month name Jan, Feb etc.
dependent
upon the serial date number held within that cell. It does not require
the
use on the MONTH() function, which returns a numeric 1 to 12.

Alternatively rather than a long Lookup, you can use =Text(A1,"mmm")
to
return Jan, Feb, etc.

Regards

Roger Govier


Bryan Hessey wrote:
Yes, it only worked for Jan.

Better is


=LOOKUP(MONTH(A1),{1,2,3,4,5,6,7,8,9,10,11,12},{"j an","feb","mar","apr","may","jun","jul","aug","sep ","oct","nov","dec"})

which accomodates the other eleven months also.


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=487578