Idendify cells that haven't been modified in the last 2 weeks

[catalincirjan]

Hello,

I am trying to identify the cells in an array that haven't been modified in the past 2 weeks and have a list of those cell references.
Array in question: F3:T500
Sheets:
1.cells in present time "Tracks"
2. cells as they were 2 weeks ago "Past" // the assumption is that this sheet is automatically updated with the version of Tracks of two weeks ago
Precondition: C cell value for that row equal "In Progress"


What I was thinking of is a formula per row that will look like =IF(C3="In Progress",here use formula with array F3:T3 ,"")
Now regarding the formula inside this if, I have been trying to use the CELL/ADDRESS formula in combination with IF(Tracks!F3:T3=Past!F3:T3), but I can't get anywhere ...

All of this also goes on my assuption that the formula will Spill for the entire row and then I can modify the formula for each row that will also Spill eventually?!

Any advice is highly appreciated!
Hope I was able to explain what it is I want to do here ....

 

[Fluff]

Cross posted Identify cells that haven't been modified in the last 2 weeks

While we do allow Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered elsewhere.

 

[catalincirjan]

Solution on link above. Thank you!