Feb 06 2023 10:59 AM - edited Feb 06 2023 11:41 AM
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.
Thank you!
=MAX('Resident Line List'!AK:AK,'Staff Line List'!AK:AK)
Feb 06 2023 11:39 AM
Feb 06 2023 11:41 AM
Feb 06 2023 11:43 AM
largest or "oldest" is ambiguous too. Do you want the earliest date or the latest date?
Feb 06 2023 11:53 AM
= MAXIFS(dates, dates, "<99999")