A AJM New Member Sep 20, 2010 #1 I enter =IF(C2<>"",IF(B2="",NOW(),B2),"") in column B and when there is an entry in column C a date is entered in column B. I want to have that apply to range of cells, so when there is an entry in column C-H then the timestamp applies.
I enter =IF(C2<>"",IF(B2="",NOW(),B2),"") in column B and when there is an entry in column C a date is entered in column B. I want to have that apply to range of cells, so when there is an entry in column C-H then the timestamp applies.
Hui Excel Ninja Staff member Sep 20, 2010 #2 What about =IF(COUNTA(C2:H2)<>0,IF(B2="",NOW(),B2),"") If that formula is going in B2 shouldn't it read? =IF(COUNTA(C2:H2)<>0,IF(B1="",NOW(),B1),"") so that it is checking the cell above itself
What about =IF(COUNTA(C2:H2)<>0,IF(B2="",NOW(),B2),"") If that formula is going in B2 shouldn't it read? =IF(COUNTA(C2:H2)<>0,IF(B1="",NOW(),B1),"") so that it is checking the cell above itself
