Prev: SumProduct counting negative numbers
Next: Formula adding 2 days...
From: Zoe on 15 Apr 2010 17:39
I'm calculating a date 5 years in advance for a lot of cells. If the original
(J4) date is blank how do I tell it to leave the new date blank also? Does
that make sense? Thansk.

=DATE(YEAR(J4)+5,MONTH(J4),DAY(J4))
From: ck13 on 15 Apr 2010 17:47
Try =IF(J4="","",DATE(YEAR(J4)+5,MONTH(J4),DAY(J4)))

"Zoe" wrote:

> I'm calculating a date 5 years in advance for a lot of cells. If the original
> (J4) date is blank how do I tell it to leave the new date blank also? Does
> that make sense? Thansk.
>
> =DATE(YEAR(J4)+5,MONTH(J4),DAY(J4))
From: Zoe on 15 Apr 2010 17:56
That worked perfect!!!! Thank you so very much!!!

"ck13" wrote:

> Try =IF(J4="","",DATE(YEAR(J4)+5,MONTH(J4),DAY(J4)))
>
> "Zoe" wrote:
>
> > I'm calculating a date 5 years in advance for a lot of cells. If the original
> > (J4) date is blank how do I tell it to leave the new date blank also? Does
> > that make sense? Thansk.
> >
> > =DATE(YEAR(J4)+5,MONTH(J4),DAY(J4))
From: Dana DeLouis on 17 Apr 2010 10:27
Hi. Just note that if the original date is 2/29/2004
then Year(J4)+5 rounds forward to Mar 1
EDate rounds back to Feb 28.

If you wish to round back, then maybe:
=IF(J4="","",EDATE(J4,60))

= = = = =
Dana DeLouis




On 4/15/10 5:56 PM, Zoe wrote:
> That worked perfect!!!! Thank you so very much!!!
>
> "ck13" wrote:
>
>> Try =IF(J4="","",DATE(YEAR(J4)+5,MONTH(J4),DAY(J4)))
>>
>> "Zoe" wrote:
>>
>>> I'm calculating a date 5 years in advance for a lot of cells. If the original
>>> (J4) date is blank how do I tell it to leave the new date blank also? Does
>>> that make sense? Thansk.
>>>
>>> =DATE(YEAR(J4)+5,MONTH(J4),DAY(J4))
 | 
Pages: 1
Prev: SumProduct counting negative numbers
Next: Formula adding 2 days...