Updating a cell, but stopping the update after a certain Timestamped date

Darknyte

New Member
Joined
Nov 10, 2020
Messages
2
Office Version
  1. 2016
Platform
  1. Windows
Hello, I am using Timestamp (NOW()) to fill out an IF function:
=IF(AND(S21>=O37,S21<S37),S17,0)

Where S21 is my Timestamped date, O37 is my minimum date and S37 is my max date, S17 is a percentage that updates as data is updated. The data updating is what updates the timestamp. Instead of 0 in the FALSE statement, however, I would like for it to take the last known reading of S17 and keep the cell populated.

In easier terms, when the administrator updates the cell to show completion of work, it updates the date when she updates the cell. To show progression of work completed, I have different tables showing progression as of a certain date (row 37). If I could get this to work, she would only literally have to enter in the data in one or two columns and it would automatically show progression as time went along.

anyone?
 

Some videos you may like

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

Darknyte

New Member
Joined
Nov 10, 2020
Messages
2
Office Version
  1. 2016
Platform
  1. Windows
=IF(T17>0,NOW(),"") Where T17 is a cell that is the Total of a row of data entered by our administrator. I am finding out, though, that wherever I update the worksheet, it updates the timestamp, not just when the cell T17 is greater than zero!.. HELP! :)
 

Watch MrExcel Video

Forum statistics

Threads
1,122,850
Messages
5,598,457
Members
414,239
Latest member
xnanx

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top