Finding the earliest date in a range of dates
In one row I have an array of 10 dates spanning a decade e.g 2010 – 2019.
1/4/2010, 6/7/2011, 3/5/2012, 2/3/2013 …..etcI need a formula that will find the earliest of those 10 dates using only the day and the month while ignoring the yearObviously if it’s searched with MIN(A1:J1) for the earliest date then it would produce the 2010 (1/4/2010) date but the earliest date based on only day/month is 2/3/2013.
how can my search ignore the year?
In one row I have an array of 10 dates spanning a decade e.g 2010 – 2019. 1/4/2010, 6/7/2011, 3/5/2012, 2/3/2013 …..etcI need a formula that will find the earliest of those 10 dates using only the day and the month while ignoring the yearObviously if it’s searched with MIN(A1:J1) for the earliest date then it would produce the 2010 (1/4/2010) date but the earliest date based on only day/month is 2/3/2013. how can my search ignore the year? Read More
