Forum Discussion
Stop recalculating formula past a set date?
I have a summary file that links to each of my project files, respectively. I update the project files weekly. My summary file is set up with column A-C being my project info, Row 2 is my dates, and ...
I use IF for staff timesheets which are collated on a master sheet.
Basic version is in cell A2 put:
IF today = date cell(example uses A1), keep cell A2, else get the data from A55 or wherever you collect it from. I also add a 5 day grace, but instead of more than > either on its own or with a number, you can use =.
The below stops updating cell A2 from the input in cell A55 once today is more than 5 days after the date in cell A1.
Formula for A2 which you can copy down and across. Just need your dates in the same row as the A$1 in this example.
=IF(Today()>(A$1+5),A2,A55))