I have this formula that obviously doesn't work but it shows what I'm trying to do.
C3: =TODAY()![]()
=IF(C3>DATEVALUE("1/1/17"),0, "BB206")
Basically I need the formula to display a 0 until the date in C3 is 1/1/17 or later.
Once 1/1/17 passes, I need to display the contents of cell BB206
This formula will need to be in cell N6.
Bookmarks