From: (E-Mail Removed) - view profile
Date: Thurs, Nov 16 2006 9:24 pm
Email: "learning_co...@hotmail.com" <learning_co...@hotmail.com>
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 <peter...@verizonXSPAM.net>
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?

"learning_co...@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


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

A1 is cell on the expreadsheet


Date on A1: 05/31/1964

Thanks

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

"(E-Mail Removed)" wrote:
>
> From: (E-Mail Removed) - view profile
> Date: Thurs, Nov 16 2006 9:24 pm
> Email: "learning_co...@hotmail.com" <learning_co...@hotmail.com>
> 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 <peter...@verizonXSPAM.net>
> 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?
>
> "learning_co...@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
>
> ************************************************************************
> Hi Dave,
>
> A1 is cell on the expreadsheet
>
> Date on A1: 05/31/1964
>
> Thanks

--

Dave Peterson

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 wrote:
> Any chance you'll share what's in A1?
>
> "(E-Mail Removed)" wrote:
> >
> > From: (E-Mail Removed) - view profile
> > Date: Thurs, Nov 16 2006 9:24 pm
> > Email: "learning_co...@hotmail.com" <learning_co...@hotmail.com>
> > 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 <peter...@verizonXSPAM.net>
> > 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?
> >
> > "learning_co...@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
> >
> > ************************************************************************
> > Hi Dave,
> >
> > A1 is cell on the expreadsheet
> >
> > Date on A1: 05/31/1964
> >
> > 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.



"(E-Mail Removed)" wrote:
>
> 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 wrote:
> > Any chance you'll share what's in A1?
> >
> > "(E-Mail Removed)" wrote:
> > >
> > > From: (E-Mail Removed) - view profile
> > > Date: Thurs, Nov 16 2006 9:24 pm
> > > Email: "learning_co...@hotmail.com" <learning_co...@hotmail.com>
> > > 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 <peter...@verizonXSPAM.net>
> > > 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?
> > >
> > > "learning_co...@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
> > >
> > > ************************************************************************
> > > Hi Dave,
> > >
> > > A1 is cell on the expreadsheet
> > >
> > > Date on A1: 05/31/1964
> > >
> > > Thanks
> >
> > --
> >
> > Dave Peterson

--

Dave Peterson