Change text in a cell depending on date in another cell

=IF(A2>=TODAY(),"Report", "In Life")

where A2 is the date you wish to check. Note that in this example, A2 would have to be changed in each formula if checking multiple dates.

Alternately

 =IF(A2<TODAY(),"Protocol", IF(A2=TODAY(), "In Life", "Report"))

would produce "Protocol" if the date was earlier than TODAY(), "In Life" if the date was equal to TODAY(), or "Report" if the date was after TODAY().

Again, A2 would need to be changed for each formula with the correct date to check.

As a side note, if you get a long number rather than a date, make sure the cell with the formula is formatted to display dates.