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,