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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date Format turn to Year 3
Add a sequence number(question number) to a paragraph which has a question and 4 options and answer 0
Dumb question alert! What program to use? 0
Complex Time Window / date based calculation 1
Count YEAR value? 3
week numbers 7
Add partial year to date 2
Remove date format? 3

Top