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
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