Excel Fixed Date Formula [Closed]

Report

Kaleem73

Posts: 1
Registration date: Friday April 28, 2017
Status: Member
Last seen: April 28, 2017

- Apr 28, 2017 at 08:57 AM

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

Excel Fixed Date Formula
Excel @ symbol in formula ✓ - Forum - Excel
Excel all sheets formula - How-To - Excel
Excel - Changing cell formula to text - How-To - Excel
Excel - Copy down formula if cells non-blank - How-To - Excel
Excel - Data validation formula - How-To - Excel

Excel Fixed Date Formula [Closed]

Your reply

Subscribe To Our Newsletter!