View Single Post
  #1   Report Post  
Jane
 
Posts: n/a
Default if data in one cell, then date in adjacent cell

column A is for date and column B is for data entry. I want column A to
populate with date when dat is entered into the adjacent cell in column B.

Currently, in column A, I have:
=if(b10,today(),"").

The date does populate when I enter data in column B BUT every day I proceed
down column B and enter data, the date changes in every cell in column A to
the SAME DATE.
How can I have the date stay at the date on whcih the data was entered?
thanks! jane