I have a worksheet with a list of truck lines. In this worksheet is a column of insurance expiration dates. I would like another worksheet to pull only the truck lines that the insurance has expired. Any suggestions?
If the expiry date is in A1 then, place this in another cell.
=IF(TODAY()>A1,"Expired",IF(TODAY()+1>A1-1,"About to Expire","Not expired"))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks