Formating a cell based on last value in column

[Urlord]

I have two columns that contains dates
Column b Out Of Service Date
Column F Return to service

I need a formula that takes the newest date and enters text in C2
If the newest date is in Column B I need C2 to say "Out of Service"
If the newest date is in column F I need C2 to say "In Service"
The row number in each column changes when a new entry is made so the formula needs to look at the last entry in the columns

Any help would be appreciated

 

[Zack Barresse]

If order doesn't matter, just use the MAX() function to grab the largest date per column. Then you could just test the two against each other, i.e. =IF(MAX(B:B)>MAX(F:F),"b has higher date","f has higher date")

 

[Urlord]

Perfect
Thank you