Month in one cell. Year in another. How?

[eddy]

I need to shown the current month (text), in say cell A1 and the current year in cell B1.
If A45 = <=NOW()> then
=YEAR(A45) in cell B1 gives me the current year OK but =MONTH(A45)entered in cell A1 just gives 4.
I am sure the answer is simple but I dont know what it is. Help!!
eD

 

[Aladin Akyurek]

On 2002-04-06 12:37, eddy wrote:
I need to shown the current month (text), in say cell A1 and the current year in cell B1.
If A45 = <=NOW()> then
=YEAR(A45) in cell B1 gives me the current year OK but =MONTH(A45)entered in cell A1 just gives 4.
I am sure the answer is simple but I dont know what it is. Help!!
eD

In A1 enter: =IF(B1,TEXT(A45,"MMM"),"")

In B1 enter: =IF(A45<=TODAY(),YEAR(A45),"")