I have a set of dates that is generated by a system where the first entry is set up as 1900, looking at the year only. Every time an entry is made, a new date is added to the related column list. I am working on setting up some form templates and will need a formula or some way to find the oldest date, excluding 1900. I do not believe that the dates will always be in order.
I have tried =MIN( functions and also a few different =IF( statements but have had no luck.
Is there a way to write a statement - =IF(MIN(A1:A10)>1900, MIN(A1:A10), IF(MIN(A1:A10)=1900, then give me min(A1:A10) value that is greater than 1900?
1922
1925
1950
1900
2000
2002
2010
2017
Thanks for any help or other thoughts!
Bookmarks