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.
Bookmarks