Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Leave "formula cell J7" empty until H7 has a date.
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Leave "formula cell J7" empty until H7 has a date.
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Leave "formula cell J7" empty until H7 has a date.
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
How do I return "leave cell blank" using IF logic. | Excel Worksheet Functions | |||
To leave a cell blank following an "IF" function | Excel Worksheet Functions | |||
a formula that leaves cell "empty"? | Excel Worksheet Functions | |||
Leave cell data (IF(ISNA(VLOOKUP) is TRUE instead of returning blank (" ") or #NA | Excel Worksheet Functions |