I'm trying to update the column B with today's date based on the date value in column A and a couple of other values in other columns. If column B is already populated, I need to leave it untouched. I'm trying to get this in a macro so one could click a button to have this updated. The will be new records added to this spreadsheet every week and this update would be necessary.