Forum Discussion
Can I make a cell value appear only after a certain date?
Sorry, I forgot to correct the reference when copy/paste your initial formula.
=IF(TODAY()>=DATEVALUE("07/01/2018"), Jun!V24, "")
Still not working :( Not sure if I am doing something wrong. Thanks for your help.
Sorry, I forgot to correct the reference when copy/paste your initial formula.
=IF(TODAY()>=DATEVALUE("07/01/2018"), Jun!V24, "")
In Sam's example, how can you freeze that value after that date passes.. won't it change as the totals change (after the Date passes)? I'm not sure I'm wording this right 🙂
Sorry, not sure I understood what is required. Perhaps you may illustrate by your own sample?
We have a monthly membership where people join for a fee and stay any number of months, (There are 2 levels of membership) I keep track of the number of members, and the total fees incoming. I'd like to have a snapshot of those totals at the end of each month, I tried the formula you gave to Sam, but the "June" total kept updating even after June. I'd like that number to 'freeze' at the value it is on Jun 30 and not change afterwards. Then I'd have totals for each month.. ....ex. Jun had 23 members and $941 in income, etc
https://docs.google.com/spreadsheets/d/1MHbsVWtHziCHNDX2KEm8PprVq4KtZPAuVG0ZM7V1ktA/edit?usp=sharing
SergeiBaklan I'm trying to implement the formula you've helped Sam Maw with... I've got it work ok, however I wanted the "TODAY" to pull from a date from another cell (C4 in my example) and I also want the "DATEVALUE" to pull a date from a selected cell (A7 in my example) see screenshot below...
 
I'm a bit of an Excel novice, Is this possible?
I've also attached the excel sheet
Thanks
m.
SergeiBaklan Hi, I have seen your guidance and must appreciate your knowledge. I have tried the same formula, where I want 1 in every cell after the chosen date and the earlier cells with dates should apprear ZERO. The formula isn't working for some reasonhttp://"C:\Users\jq\OneDrive\09 Data JQ\Sample WorkBook.xlsx" . Any guidance will be appreciated. Thank you.
Yes! Thank you! I got it. Thanks for your help!
