=TEXT(A1&"-1","mmmm yyyy")
=TEXT("1-"&A1,"mmmm yyyy")

Depending on your regional date settings Excel will interpret an entry like
1-2 or 2-1 as a valid date of the current year. For examle, with my regional
date settings as U.S. English, if I type in cell A1 2-1 Excel automatically
evaaluates that as a date and displays 1-Feb.

Basically, in the formula we're just taking advantage of Excel's eagerness
to identify dates!

--
Biff
Microsoft Excel MVP


"yclhk" wrote in message
...
Hi, K****ij,

Actually, i wish to know how does the Date & Text function work in the
formula ? Why "A1+1" in your formulae and "1-"&A1 in Valko formulae ?

Thanks,


"K****ij" wrote:

Well in may case it was simple that i had formated the cell to just show
the
month and Year..... Remember we had done-- right click on cell... Format
and
then Number and Custom...... and TYpe..... "MMMM YYYY", this mad it to
text,
and the Date formula is the regular date formula..... nothing else.....
So
chill.....

If you found the answer useful, Please press yes at bottom.... Ok....

"yclhk" wrote:

Hi, K****ij & Valki,

Thanks for your formula. Pls be kind to explain how the Date & Text
worked
in this formula.

Thanks,


"K****ij" wrote:

Well Check out this formula......
I belive, it should be sufficient......

First custmosize the B1 to format(custom) in that have it as mmmm
yyyy

Then put the formula in B1 as =Date(2009,A1+1,0)

Well it will return as Feburary 2009,

Now I hope that is helpful and simple....

And if you ask me why I have taken "A1+1" the i am not aware but it
works
that way.....

"yclhk" wrote:

How to convert the month in number to the month in text ?
For example :

in cell A1 enter 2
in cell B1 display February 2009

Thanks,