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, "")
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.
