Ken,

i think that the function like month() or year() converts the date value in
an integer value...hence if you need to show different date format while
retaining the real date value, better stick with the date value and play with
the formatcellnumbersdate ...so you dont loose the logical conversion.

regards
--
*****
birds of the same feather flock together..



"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