Today() ... Month() ... Formatt mmm

[Guest]

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]

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.

 

[Guest]

Too complicated. Make C2:
=B2

remember that
3
is actually
Tuesday, January 03, 1900

 

[Guest]

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 format>cell>numbers>date ...so you dont loose the logical conversion.

regards

 

[Guest]

Thanks all ... C2 is now B2 ...

Thanks ... Kha