Formula for 2 different dates

Hi All,


I need to be able to search data were we have 1 client with multiple expiry dates of policies. 

We need to pull the data of the oldest expiry against another spreadsheet pulled from a system which contains details of diary tasks on when to contact the customer and reconcile the dates against each other.

Can anyone help?




  A B
1 Name Policy Expiry
2 JohnSMith 31-Aug-17
3 JohnSMith 30-Aug-17

By: JAson

Leave a Reply

Your email address will not be published. Required fields are marked *