Forum Discussion
IF formula for adding date changing previous dates to current date
Forgive me, as this is my first time using this forum. I have been using a formula to add the current date to a column of cells when text is added to a specified cell. See example formula below: ...
Maybe with the Worksheet_Change event. In the attached file you can make an entry in any cell in column B and today's date is added in the adjacent cell in column A. The date in column A is only overriden if a new entry in the adjacent cell in column B is made.