Date Format turn to Year

  • Thread starter Thread starter learning_codes
  • Start date Start date
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
 
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...
 
Back
Top