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?
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
=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! :)
 
Upvote 0

Forum statistics

Threads
1,214,528
Messages
6,120,064
Members
448,941
Latest member
AlphaRino

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
Back
Top