View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sheeloo[_3_] Sheeloo[_3_] is offline
external usenet poster
 
Posts: 1,805
Default 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 ?