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

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

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

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

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

Too complicated. Make C2:
=B2

remember that
3
is actually
Tuesday, January 03, 1900

--
Gary''s Student
gsnu200708


"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

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

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

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

Thanks all ... C2 is now B2 ... :)

Thanks ... Kha

"Gary''s Student" wrote:

Too complicated. Make C2:
=B2

remember that
3
is actually
Tuesday, January 03, 1900

--
Gary''s Student
gsnu200708


"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