Dan,

This question; at least to me, isn't clear. What are you entering and where
and what is the formula you are referring to?

If you enter something like
=YEAR(15-05-07)
Excel will evaluate that as 15-5-7=3 and come up with a year of 1900




--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"DanWebster24" wrote:

In the Function Arguments dialog the official Formula Result is different
(and wrong) from the result shown after "=" just under the Serial number
field.
I am using the Year formula. Whatever formatting I use for the date neither
this formula nor Text to Columns can return the correct year.
EG: Date is 15-05-07 or 39217, Forumula Result = 1905 but under serial
number field it shows the correct result of = 2007