Add years NOT days

Coza · External Since: Mar 23, 2007 Posts: 2

In the following formula, J4 is (dddd dd mmmm yyyy) and H4 is (2)
[Representing Years].
=IF(J4<>"",J4+H4,"")

Currently it ADD's Days, how can i convrt the formula to ADD years ?

Corey....

Max · External Since: Mar 17, 2004 Posts: 1751

Try:
=IF(J4<>"",DATE(YEAR(J4)+H4,MONTH(J4),DAY(J4)),"")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Coza" wrote:
> In the following formula, J4 is (dddd dd mmmm yyyy) and H4 is (2)
> [Representing Years].
> =IF(J4<>"",J4+H4,"")
>
> Currently it ADD's Days, how can i convrt the formula to ADD years ?
>
>
> Corey....
>
>
>
>

Coza · External Since: Mar 23, 2007 Posts: 2

Thanks Max.
Perfect

"Max" <demechanik DeleteThis @yahoo.com> wrote in message
news:C153BD95-EF18-4934-80DA-FDDD96FA52A8@microsoft.com...
> Try:
> =IF(J4<>"",DATE(YEAR(J4)+H4,MONTH(J4),DAY(J4)),"")
> --
> Max
> Singapore
> http://savefile.com/projects/236895
> xdemechanik
> ---
> "Coza" wrote:
>> In the following formula, J4 is (dddd dd mmmm yyyy) and H4 is (2)
>> [Representing Years].
>> =IF(J4<>"",J4+H4,"")
>>
>> Currently it ADD's Days, how can i convrt the formula to ADD years ?
>>
>>
>> Corey....
>>
>>
>>
>>

Max · External Since: Sep 08, 2003 Posts: 3335

Welcome, Coza
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Coza" <coza.DeleteThis@exemail.com.au> wrote in message
news:OD8JznRbHHA.1240@TK2MSFTNGP04.phx.gbl...
> Thanks Max.
> Perfect