Forum Discussion
jaolvera
Feb 06, 2023Brass Contributor
Calculate Maximum date excluding a specific date
I needed assistance with calculating the largest or oldest date in two different columns. I want the date 12/31/9999 to be excluded, as it is a date that populates due to a formula in the cells. Th...
PeterBartholomew1
Feb 06, 2023Silver Contributor
Assuming the dates are not more than 150 years in the future
= MAXIFS(dates, dates, "<99999")