Small Function

[Tikey]

Hi

I have a column with hundreds of dates over several years. I wish to be able to find the earliest date within a particular year, the data is on a different sheet to where I am trying to do this, in this case you will see it is on a sheet called Records.

=smallif(Records!$F:$F,">=1994-1-1",Records!$F:$F,"<1995-1-1")

The above returns a Name error.

Can anyone help ?

Thanks

 

[Legacy 421546]

Just sort the dates first. Or use VBA.

Or give us a sample how it looks.

 

[Ron Coderre]

If your version of Excel has the AGGREGATE function....
this regular formula returns the smallest Col_F date, on the Records tab, that is within 1994:

=AGGREGATE(15,6,Records!$F:$F/(YEAR(Records!$F:$F)=1994),1)

Is that something you can work with?

 

[Tikey]

If your version of Excel has the AGGREGATE function....
this regular formula returns the smallest Col_F date, on the Records tab, that is within 1994:

=AGGREGATE(15,6,Records!$F:$F/(YEAR(Records!$F:$F)=1994),1)

Is that something you can work with?

Ron

That works fine and easily adjusted for the latest date as well.

Thanks very much for your help.

Dave