Blanking Cells

[jjcsjc]

Cell A1 has 23-Oct or 25-Oct
Cell A2 has formula =if(day(A1)<24,A1+7,"")
Cells A3:A6 have text
When cell A1 is 25-Oct cell A2 is blank. I want cells A3:A6 to be blank also.

 

[kskinne]

does the text in cells A3:A6 change or is it always the same?

kevin

 

[jjcsjc]

Always the same

 

[kskinne]

then put the following formula in cells A3:A6:

=IF(DAY(A1)<24,"replace with your cell's TEXT","")

and for each cell, replace TEXT with the text that actually belongs in that cell.

HTH
kevin

 

[jjcsjc]

Thanks, it works great.