I am having trouble creating a formula for these dates. My goal is to create something that will compare all the dates listed. It should do so by taking dates 1-5 and adding 5 years to them, and adding 6 months to "date 6 months" then it should display the lowest of these values in expiration date. It has been giving me a lot of issues and I'm also not sure how to make it so it ignores cells that are empty, as excel assumes the date is 1900 when the cell is blank.
Bookmarks