Date Format turn to Year

L

learning_codes

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
 
D

Dave Peterson

What's in A1?

Are you sure it's a real date?



[email protected] said:
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
Click to expand...
 
Top