Excel Fixed Date Formula

Kaleem73 Posts 1 Registration date Friday April 28, 2017 Status Member Last seen April 28, 2017 - Apr 28, 2017 at 08:57 AM

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")