Hi...

I have a spreadsheet that requires status, start dates and expiration dates. My goal is to create a function that will change the text in the "Status" column to "Expired" automatically when the "Expire" column has a date in the past. "Expired" is not the only text that is shown in the cells in the Status column. The additional entries may be New, Renewal, etc. Those need to stay the same.

Column O = PB Status = Text Only (ie., Expired, New, Renewal)
Column P = PB Start = Dates Only
Column Q = PB Expire = Dates Only

It was my thought initially to create a macro to perform this task, but I need the formula first and can't make mine work within the large range of cells I have. My attempt at the formula is as follows:

=IF(Q2:Q1000 < Today(), "Expired")

This doesn't work of course. I've also tried naming the ranges in the columns and placing them in the formula, but I can't figure it out.

Any help would be greatly appreciated. Thanks!