How do I get the current date to autofill
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 ?
|