Min-function with Year Filter

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.

@Ali: do you mean something like this?

{=MIN(IF('Play List'!E3:E1000=DATE(2019;1;1);'Play List'!E3:E1000))}

This only returns 0. My list is always expanding and has at the moment 150 entries so many parts are blanc in the E3:E1000 range.


@Roel Jongman: =INDEX('Play List'!E3:$E1000;MATCH(DATE(2019;1;1);'Play List'!E3:E1000;1)) gives me #N/A.

What am I doing wrong?

hard to guess without the example file but your formula is not te same as mine

try this

Formula:

Please Login or Register  to view this content.

if there are gaps in your list or blank rows between dates it can return an error (I guess)