John

In a helper cell enter =YEAR(cellref)


Gord Dibben MS Excel MVP

On Tue, 9 Jan 2007 08:22:00 -0800, JohnU
wrote:

I am using the NOW() function to insert the current date. This works fine,
except I am attempting to extract only the year (i.e. 2007) from this
function.

The problem is that Excel expresses the value of the date as a number (x
number of days from January 1, 1900). I can get the format to display the
date in an mm/dd/yyyy format, I just can not extract the year all alone. I
need to get the year by itself for another calculation.

Any ideas?