I am trying to create a formula which calculates "Proposals in Limbo". The idea is that it sums values from a Proposal Tracker spreadsheet which are not "Won" or "Lost" yet.
Problem I am having is that the formula keeps calculating. I would like the value to lock after the end of each week.
If Today() is within this week dates, then calculate and display the newest values as the references Proposal Tracker is updated. If Today() no longer is within this weeks dates (meaning the previous data is now from last week) I want the value in the cell to freeze.
Week 1 value should be different than Week 2, Week 3, etc. Formula calculates the data for this week, but stops calculating once the week is done and shows the last calculation for that week.
Problem I am having is that the formula keeps calculating. I would like the value to lock after the end of each week.
If Today() is within this week dates, then calculate and display the newest values as the references Proposal Tracker is updated. If Today() no longer is within this weeks dates (meaning the previous data is now from last week) I want the value in the cell to freeze.
Week 1 value should be different than Week 2, Week 3, etc. Formula calculates the data for this week, but stops calculating once the week is done and shows the last calculation for that week.