Is there a way to get this formula to work for multiple rows?

in other words would i change the variable (B1:01) to (B2:02) and increase
it incrementally for each row? or is there another way to do it?

would it be easier to use a named range and name the column that i want to
look at in order to populate the date column?

"Sheeloo" wrote:

Yes, there is.

Enter this in A1
=IF(COUNTA(B1:O1),TODAY(),"")
Change O to the last column you want
and copy down...

You may have to format Col A as Date...

"digitalmuse" wrote:

Is there a way to get the current date to populate in a cell whenever there
is information typed in a row

for example row 1 contains several colums of information the first row
which would be A1 would be labled "Date" so when someone enters information
into row one in any of the colums the current date would show up in colum a
same for any of the rows

is there a formula to do this ?