Month in one cell. Year in another. How?

eddy · Apr 6th, 2002, 01:37 PM

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 · Apr 6th, 2002, 01:48 PM

Quote:

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),"")

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 6th, 2002, 01:37 PM	#1
eddy Board Regular Join Date: Mar 2002 Posts: 473	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