Hi,
try

=IF(COUNTA(B3:B43)0,TODAY(),"")

if this helps please click yes, thanks

"RJ Swain" wrote:

Hello,

I am working on a spreadsheet that in cells B3:B43 I have a list that the
user can select a planet from the list. When they select a planet I would
like the worksheet to auto fill in the current date in cell O3. And when
cells B3:B43 are blank cell O3 will be blank as well.