Try formatting A1 as an unambiguous date.

Give it a custom format of:
mmmm dd, yyyy

What do you see?



Andy wrote:

Hi Biff,

Same result to show Jan only, why????

"T. Valko" wrote:

Try it like this:

=IF(ISNUMBER(A1),TEXT(A1,"mmm"),"")

Biff

"Andy" wrote in message
...
Hi there,

I used the function but the result show "Jan" only, please help!!!

A1 : 15/4/07
B1 : =IF(ISBLANK(A1),"",MONTH(A1)) 'show 4 in the cell
C1 : =Text(IF(ISBLANK(A1),"",MONTH(A1)),"mmm") 'show Jan in the cell

"Elkar" wrote:

Try this:

=TEXT(A1,"mmm")

HTH,
Elkar


"Bob" wrote:

Example:
Cell A1 = 11/17/2007
Using a function/formula, I would like cell B1 to display "Nov"
(without
using any date formats) . . . as if I had simply typed "Nov" (without
the
double quotes) in cell B1.
I would greatly appreciate any help.
Thanks,
Bob




--

Dave Peterson