Prev: Filtered data range reference is too complex
Next: Broken Excel hyperlink to Word Template
From: Mark on 20 May 2010 14:13
I have the following formula in cell J7

=DATE(YEAR(H7),MONTH(H7)+6,DAY(H7))

This gives me a date in J7 that is 6 months forward from the date I will
enter in H7.

I would like J7 to stay empty (blank) until needed.

Right now the formula works but I get a generic date in J7 of 6/30/00 and I
not only don't know why, I would that not like that to happen.

The date in J7 should be six months forward of H7.

Sorry for being so verbose, I am always afraid I do not ask the right
question.

Thanks to all you experts in advance. For your time, your patience and your
teaching capabilities.

Mark
From: Eduardo on 20 May 2010 14:21
Hi,

=if(H7="","",=DATE(YEAR(H7),MONTH(H7)+6,DAY(H7)))

"Mark" wrote:

> I have the following formula in cell J7
>
> =DATE(YEAR(H7),MONTH(H7)+6,DAY(H7))
>
> This gives me a date in J7 that is 6 months forward from the date I will
> enter in H7.
>
> I would like J7 to stay empty (blank) until needed.
>
> Right now the formula works but I get a generic date in J7 of 6/30/00 and I
> not only don't know why, I would that not like that to happen.
>
> The date in J7 should be six months forward of H7.
>
> Sorry for being so verbose, I am always afraid I do not ask the right
> question.
>
> Thanks to all you experts in advance. For your time, your patience and your
> teaching capabilities.
>
> Mark
From: Jacob Skaria on 21 May 2010 02:13
Try
=IF(H7,DATE(YEAR(H7),MONTH(H7)+6,DAY(H7)),"")

--
Jacob (MVP - Excel)


"Mark" wrote:

> I have the following formula in cell J7
>
> =DATE(YEAR(H7),MONTH(H7)+6,DAY(H7))
>
> This gives me a date in J7 that is 6 months forward from the date I will
> enter in H7.
>
> I would like J7 to stay empty (blank) until needed.
>
> Right now the formula works but I get a generic date in J7 of 6/30/00 and I
> not only don't know why, I would that not like that to happen.
>
> The date in J7 should be six months forward of H7.
>
> Sorry for being so verbose, I am always afraid I do not ask the right
> question.
>
> Thanks to all you experts in advance. For your time, your patience and your
> teaching capabilities.
>
> Mark
 | 
Pages: 1
Prev: Filtered data range reference is too complex
Next: Broken Excel hyperlink to Word Template