I want to fix the date in a cell with a formula whenever other cell is populated.
e.g when cell B1 is populated, cell A1 should show the date of that day and that should not change later on.
I have seen some posts with the same question but with no answer.
any guru on this..??