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