|You never mentioned C2 in your OP so I didn't know what it was being used for. You referred to C1 twice, but then never used C1 in any of your formulas. Thus my confusion.|
Anyway, here's what I tried:
I put =TODAY() in C2. It returned 4/18/2013.
I put =IF(B12="","",SUM(B12+30)) in C12. It returned "" because B12 is empty.
I put =IF(C12="","",IF(C12<C2,"","X")) in H12. It returned "" because B12 is empty.
I then entered 3/15/2013 in B12:
C12 now displays 4/14/2013 and H12 still displays nothing because C12<C2.
I then entered 4/15/2013 in B12:
C12 now displays 5/15/2013 and H12 now displays X because C12>C2.
Isn't that what you want?
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.