is it possible to use dates in a formula to activate a formula and then at a designated time stop the formula from working but keep the results of the last recording?
I have a report that I pull data from on a monthly basis. what I would like is for the report to automatically pull all the data and put it in an area designated to that Month on the report. when that month ends the data is recorded in the area for the next month. but I don't want the data from the last month to change.
my current formula is
=if(((today())<=M3), (IF((S12+30)<=M3,0,2)))
M3 is the date the formula should start working
S12 is the location of the data I want pulled out and manipulated
Does anyone have any ideas how I can do this?
I have a report that I pull data from on a monthly basis. what I would like is for the report to automatically pull all the data and put it in an area designated to that Month on the report. when that month ends the data is recorded in the area for the next month. but I don't want the data from the last month to change.
my current formula is
=if(((today())<=M3), (IF((S12+30)<=M3,0,2)))
M3 is the date the formula should start working
S12 is the location of the data I want pulled out and manipulated
Does anyone have any ideas how I can do this?
