'I would like to enter a future date in a cell and when it reaches that date the cell goes blank

I am working on a on call sheet, in column f it is a "do not call until further notice". I would like to be able to put a future date in that cell and when that comes it clears the contents in that cell. I am using a filter function and when it looks at the do not call column it is looking for a blank cell to move the info to the proper sheet. Everything works great accept trying to get the date to disappear thanks in advance.

google-sheetsjavascripthtmlcss


Solution 1:[1]

I would like to enter a future date in a cell and when it reaches that date the cell goes blank

=IF(TODAY()="12/12/2033"; "12/12/2033"; )

Solution 2:[2]

You can use viewport units and max/min properties:

#boxes .window {
  position:absolute;
  left:0;
  top:0;
  width: 20vw;
  height: 20vh;
  max-width:440px;
  max-height:850px;
}

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 player0
Solution 2 first last

Related Questions