Date function
Are you sure you want to format that as date, Dave?
=YEAR(TODAY()) formatted as date will give you 29th June 1905. I would
prefer to see it formatted as General or Number.
--
David Biddulph
"Dave F" wrote in message
...
=YEAR(TODAY())
Format as date, not number.
Dave
"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?
|