When I populate B7, B8, B9, etc... I ask cell F7, F8, F9, etc. to put in today's date.
That works fine.

When I open THAT SAME excel worksheet next day, F7, F8, F9, etc. gives me TODAY'S date. Every different day that I open that same excel worksheet, it updates the date without me asking it to.

How do I tell F7... If B7 is populated, put in today's date, and leave it like that; don't refresh to a new date.

This is the current formula I am using on F7:

=IF(LEN(B7)>0,TODAY(),"")

Is TODAY the wrong function to use?