I have a worksheet table where I need to add today() date in the cell of column “G” if the same cell in row in column “E” is filled with data .. and i actually have this formula =IF($E8<>””,IF($G8=””,TODAY(),$G8),””) but I’m facing a probelm with this formula which is that when I add a new data to column “E” I got date in “G” like this (00.01.00) and I have to delete the data from E and reinter it again to get the correct date of today like (01.05.2024)

I need your help if i can do this with a Vba code or with better formula