Leave "formula cell J7" empty until H7 has a date.

M

Mark

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA format of cells with colour based on IF formula 2
help with formula to calculate what column to use 2
Macro filldown 0
Help with date/cost formula 6
Too Many IF Statements Nesting Error (Excel Formula Loop w/o VBA) 7
create a formula to know last months column character or number 0
Cell References 2
calculate 6 months forward from a date 8

Top