Re: How to calculate with years....?

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi Andrew

I do most humbly apologise. I must learn to read first and post second!!<bg>
Just as I hit the send button, I reread your posting and saw that you wanted
to add 12 years to 16/11/1993, not find the number of years between the two.

=DATE(YEAR(A1),MONTH(A1)+B1,DAY(A1))

--
Regards

Roger Govier


"Roger Govier" <roger@xxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:uX8xxQt4FHA.3976@xxxxxxxxxxxxxxxxxxxxxxx
> Hi Andrew
>
> Then you can't have 16/11/1993 in A1
> If I have A1 blank then I get 105 in both cases. You are seeing
> 14/apr/1900 because your cell is formatted as date and 14/04/1900 is 105
> days after 01/01/1900. Format the cell as general and you will see 105 in
> both cases.
>
> Enter 16/11/1993 in A1 and you will see 12 and 11, the answer of 11 being
> because we have not yet reached 16/11/2005 so we are still about 6 weeks
> short of 12 years.
>
> --
> Regards
>
> Roger Govier
>
>
> "Andrew" <NoToSPAM@home> wrote in message
> news:%23ed3AJt4FHA.2552@xxxxxxxxxxxxxxxxxxxxxxx
>> These Either return:
>> Sat-14/Apr/1900
>> Or
>> 105
>>
>> Not.... 16/12/2005 ....?
>>
>> Sorry Roger your Not answering the question.
>> Thanx for trying though.
>>
>>
>> "Roger Govier" <roger@xxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:%23%23N9E$s4FHA.2092@xxxxxxxxxxxxxxxxxxxxxxx
>> | Hi
>> |
>> | One way
>> | =YEAR(TODAY())-YEAR(A1)
>> | or
>> | =DATEDIF(a1,TODAY(),"y")
>> |
>> |
>> | --
>> | Regards
>> |
>> | Roger Govier
>> |
>> |
>> | "Andrew" <NoToSPAM@home> wrote in message
>> | news:OZH7d6s4FHA.3036@xxxxxxxxxxxxxxxxxxxxxxx
>> | > How to calculate with years...
>> | >
>> | > IE: Date in Cell(A1) 16/12/1993
>> | > Value in B(1)= 12 (Years)
>> | >
>> | > should give date 16/12/2005
>> | > -------------------
>> | > TIA
>> | > Andrew
>> | >
>> | >
>> |
>> |
>>
>>
>
>


.

Quantcast