View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ken Ken is offline
external usenet poster
 
Posts: 590
Default 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