Hello,
In Excel if Cell A1 = 100% Cell B1 = fixed today date.
If Cell A1 = <100% Cell B1 = in Progress
In first point when date appear the date must be fixed. If I open the file next time date will be remain same.
now I am using this formula.
But when I open the file next the date change to present date.
=IF(B4=100%,TODAY(),"In Progress")