I am trying to have the date of input marked for a cell in another location
using an "IF" Function. The only problem is that when I open the sheet the
next day, it updates the date and does not solve my problem.

=IF(D3="R", TODAY(), "NA")

Any other options besides TODAY() that will help? I need it to only change
when data in the referenced cell is changed, not every time I open excel.