Date Format turn to Year

[learning_codes]

From: (e-mail address removed) - view profile
Date: Thurs, Nov 16 2006 9:24 pm
Email: "(e-mail address removed)" <[email protected]>
Groups: microsoft.public.excel
Not yet ratedRating:
show options
Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Remove | Report Abuse | Find messages by this author


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


Reply »

From: Dave Peterson - view profile
Date: Thurs, Nov 16 2006 9:39 pm
Email: Dave Peterson <[email protected]>
Groups: microsoft.public.excel
Not yet ratedRating:
show options
Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Report Abuse | Find messages by this author

What's in A1?

Are you sure it's a real date?

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


************************************************************************
Hi Dave,

A1 is cell on the expreadsheet


Date on A1: 05/31/1964

Thanks

 

[Dave Peterson]

Any chance you'll share what's in A1?

From: (e-mail address removed) - view profile
Date: Thurs, Nov 16 2006 9:24 pm
Email: "(e-mail address removed)" <[email protected]>
Groups: microsoft.public.excel
Not yet ratedRating:
show options
Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Remove | Report Abuse | Find messages by this author

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

Reply »

From: Dave Peterson - view profile
Date: Thurs, Nov 16 2006 9:39 pm
Email: Dave Peterson <[email protected]>
Groups: microsoft.public.excel
Not yet ratedRating:
show options
Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Report Abuse | Find messages by this author

What's in A1?

Are you sure it's a real date?




--
Dave Peterson

************************************************************************
Hi Dave,

A1 is cell on the expreadsheet

Date on A1: 05/31/1964

Thanks

 

[learning_codes]

A1 is a date format and I tried to convert by Year instead of DATE;

05/31/1965 (Cell Block - A1) change to 1965 (Cell block - A2) of the
Excel spreadsheet

Is that clear to you or not.. I'm talking about Excel spreadsheet?

Thanks

 

[Dave Peterson]

You don't have a date in A1. Can you format A1 as MMMM DD, YYYY

You'll see that A1 doesn't contain date.

With A1 selected, if you look at the formulabar, do you see:
=5/31/1965
with the leading equal sign?

If yes, then this is a calculation to excel:
5 divided by 31 divided by 1965
Which is equal to: 0.000082082
And if that were formatted as a date/time, it would be 7 minutes after midnight
on the first day that excel keeps track of--1900. So =year(A1) will return
1900.

If you didn't type the leading equal sign and excel just added it for you, you
have a setting toggled that you can turn off:

Tools|Options|transition tab|Uncheck all those old Lotus 123 settings.

Then reenter that date without the leading equal sign.

==
If you would have shared what was in A1 earlier, you may have gotten a faster
response.