The aim is to place a date in a cell, which is dependent on antoher cell showing the value- 100% (manuallly) and then to fix that date permanently.

The problem is that this date keeps on updating when the spread sheet is opened on a new day.

I'm using this formula and function

=IF(G81>99%,fixeddate(),"")

Option Explicit
Function FixedDate()
FixedDate = Date
End Function

Any help will be appreciated