a formula that states if a date is in or out of contract

Hi everybody

I hope you are all well!

I am trying to find a formula that tells me whether a service is in or out of contract based on the date inputted in a cell.

I have attached a spreadsheet with an example and more information. Please feel free to give it a go.

Thanks

Mike

In or Out of Contract.xlsx

Here's one way...

=IF(C5="","",IF(C5>TODAY(),"In Contract","Out of Contract"))