Add Date in cell IF...

Hey all,

Looking for a way to add today's date in adjacent cell in column B if Cell in column A has information.

I can't just paste date on a range because the quantity of rows varies.

So why not type out the date and autofill/copycell it, you ask?

Because i'd rather not I suppose.

Thank you in advance

The Information in Column Ais continuous until the end, which is why an autofill would work for manual.

Hey Glenn,

Thanks for the response.

Looking for a VBA solution.

Also the issue with Today() is that it changes to the current day, and therefore if i open the file tomorrow, it would have tomorrow's date instead of today's.