I would like to have the current date entered in one column when data is entered in the next column. Wondering if this can be done without a macro. I've thought of using the now() function but the next day of use, yesterday's dates will update to today. I'm guessing I will have to write code, which is fine, but if there was an easier way, I'm all for it.