Excel Fixed Date Formula [Closed]

Report
Posts
1
Registration date
Friday April 28, 2017
Status
Member
Last seen
April 28, 2017
-
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")

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!