=IF(COUNTIF($A$2:$A$100;">="&(H9+8));H9+8;"")
That gives me a value of 1/7/00
Got it to work when h9 has date... but when fill down if h10 is blank then h11 thru h61fills with bad data...
Zizi64 wrote:Please upload your actual version of your ODF type sample file here.
Joeywc wrote:Correct. That's my issue. I would like the others be blank if the one before is blank
=if(isnum(H9);H9+8;"")
I thought that's the reason for the if,countif code. It only supposed to calculate if there's value in row above. Otherwise leave blank
Users browsing this forum: No registered users and 25 guests