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, "")
Hi Sam,
Yes, IF works. Concrete formula depends on your data structure, like
=IF(TODAY()>DATEVALUE("2018-06-01"),<ref on the cell with May sum>,"")
and date in your locale format
SergeiBaklan is it possible for me to create a cell of text that appears after I enter a date? For example if i entered between the dates of "1965-1975" how do I make it say 'pinapple' or anything like that. I hope you understand what I'm asking? (If it is possible? How?)
Afraid not, it's better with sample file.
If you enter some text which includes dates in which exactly format you enter them (with dash, dash and spaces around, whatever).
If you enter couple of years how Excel knows this exactly range shall be marked as 'pinapple', not something else?
If ranges are overlapping?
Where to show marks?
Perhaps something else, but better illustrate on the file with manually added desired result.
SergeiBaklan Please can you help me with having a cell not calculate until two days after the current date? I have to update a daily metrics sheet that contains worked hours, but our information is always two days behind. For example, if today is Thursday, I will send out Monday's figures, (Friday's = Wednesday, but Monday, since it is two calendar days past, I can send out the full previous week, just as long as it is two calendars days past, it is okay for the formulated cell's calculation to show up). The problem is we have managers who enter transferred hours into the previous and sometimes, current date and those show up in the Week-To-Date and Month-To-Date columns. I do not want them to show up there until the other information is there, too. I pasted an example. The Wednesday information should not calculate until Friday, but it is calculating into the To-Date columns. I have been asked to get this information out of the daily reporting, and I do not want to have to paste in the new formulas each day. 😞 Please, can you help me? Thank you.
Thank you. I think I'm almost there, but it's still giving me an error. I think I'm still making a small error somewhere in the formula you gave me. Let me be more specific, and if you don't mind, you can tell me how to write the formula.
If the date is equal to or beyond July 1st 2018, I want the cell to populate the value from cell =Jun!V24. What would that look like? I tried copying your formula so it said =IF(today()>DATEVALUE("2018-07-01"), <=Jun!V24>, " "). What do I need to fix?
Thanks so muchSam, the formula will be like
=IF(TODAY()>=DATEVALUE("2018-07-01"), Jun!V24>, "")the only you have to use the date in your format. For US locale that will be like
=IF(TODAY()>=DATEVALUE("07/01/2018"), Jun!V24>, "")Still not working :( Not sure if I am doing something wrong. Thanks for your help.
