YEAR function

  • Thread starter Thread starter tdp
  • Start date Start date
T

tdp

I need to return the year in one column (Column E) from a
date in another column (Column D). Column D is formatted
as type Date, m/d/yyyy. When I put the formula "=YEAR
(D2)" in E2, it returns 6/6/1905. In fact, the formula
returns that result in all E cells, even though the dates
in the D cells are all different and none of them are
before 1984.

What am I doing wrong?

Thanks!
tdp
 
You use the wrong format, select the cell with the formula and use General
format
6/6/1905 = 1984
 
Thank you!! You would think the Help file might mention
something about that <sigh>.

Now, if I could just figure out why Autofill doesn't work-
-if I use Autofill off of the first cell, they all say
1984, even though the cell references in the formulas of
each cell are right (ex. cell E5 has formula "=year(d5)"
but returns "1984", which is not correct).

If I type in each formula manually, it returns the
correct result.

This is so frustrating!!
tdp
 
Most likely you have the calculation set to manual under
tools>options>calculation
change that to automatic or use F9 to force a calculation
 
Back
Top