Timestamp with a range of cells

[AJM]

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]

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

 

[AJM]

That's it. Thank you, that helped a bunch.