Forum Discussion
Solved
Can I make a cell value appear only after a certain date?
Hello, I'm a beginner here. Is there a formula or function I can use (perhaps a =IF?) where I can make a certain formula's value appear in a cell only after a certain date? Context: on each month...
Sorry, I forgot to correct the reference when copy/paste your initial formula.
=IF(TODAY()>=DATEVALUE("07/01/2018"), Jun!V24, "")
And how do we know that the member quits? We may calculate only active members for each month if only information who are actives exists.
Or you just remove records form the table?
I manually add and subtract them from the table when they join/quit.
Afraid that doesn't work, that's only if copy the formulas with calculations for previous period and paste the as values, after that add to totals.
I'd add to the column one more column where you may put any character if member quit and make calculations taking it into account. To show only active members you may filter the table by that column.