In the example above I have a date range.
Lets say I am looking to display the second smallest date in February 2005 (2/15/2005)
If all the dates were in Feb, I would just do the formula [=SMALL(D1:F1,2)]
but they are not.
I would like to enter in a date in say cell Z1 that says 2/1/2005.
I would like cell A2 to return a result that goes something like this:
=SMALL(B1:H1),2 where Month and Year= Z1
returning the second smallest date during the month and year specified in cell Z1.
Thanks in advance for all your help.