Hi,

How can i use an Excel Min function to find the smallest date within a spesific year?.

My list goes from year 2018-2021 and I want to find the first date on the list in year 2019.

For example my first entry for 2019 is January 10, so I want the Min function to return that date.

I know MINIFS function could do this, but I'm on an older version (2013) that doesn't support MINIFS.

All replies are welcome.