3 is third day from the start of excel's calendar (usually Dec 31, 1899 for
windows users)--so it's jan 3, 1900.

If you did
=b2
and formatted as mmm
you'd be set.



Ken wrote:

Excel2003 ...

Cell B2 formula ... =Today() ... return = 03/02/07
Cell C2 formula ... =Month(B2) ... return = 3

So far so good ...

Issue is ... when I format Cell C2 to ... custom "mmm" ... anticipating
return = "Mar" ... I get a return = "Jan".

What am I missing? ... Thanks ... Kha

--

Dave Peterson