Date Format turn to Year

Hi,

I tried to convert the date to YEAR and then the year plus 25 Years
later.

=Year(A1)    I'm getting the result  1900 instead of 1965.

I tried to add 25 years later to 1990 from 1965.

Your help would be much apprecated.

Thanks

0
11/17/2006 2:24:02 AM
excel 39879 articles. 2 followers. Follow

1 Replies
779 Views

Similar Articles

[PageSpeed] 2

What's in A1?

Are you sure it's a real date?



"learning_codes@hotmail.com" wrote:
> 
> Hi,
> 
> I tried to convert the date to YEAR and then the year plus 25 Years
> later.
> 
> =Year(A1)    I'm getting the result  1900 instead of 1965.
> 
> I tried to add 25 years later to 1990 from 1965.
> 
> Your help would be much apprecated.
> 
> Thanks

-- 

Dave Peterson
0
petersod (12005)
11/17/2006 2:39:54 AM
Reply:

Similar Artilces: