Dear Sir,
I am trying to format a date cell to return todays date if a cell in the same row is marked "Received" using the IF formula.
=IF(F1 = "RECEIVED", TODAY(),"")
But the issue in the above formula is when I open the file the next day the date changes, I want the date to be static, how...