sumproduct

im trying to get the following to work to extract the smallest date that is not a monday. This is to list all days in order where the day is not a monday.

=SUMPRODUCT(SUM(SMALL(H2:H31,1)*SUM('Data In'!H2:H31<>2)))


column H
list_date
Mon 25 Oct 04
Tue 26 Oct 04
Wed 27 Oct 04
Thu 28 Oct 04
Fri 29 Oct 04
Sat 30 Oct 04
Sun 31 Oct 04
Mon 01 Nov 04
Tue 02 Nov 04
Wed 03 Nov 04
Thu 04 Nov 04
Fri 05 Nov 04
Sat 06 Nov 04

To find the earliest date that is not a Monday...

=MIN(IF(H2:H31<>"",IF(WEEKDAY(H2:H31,2)>1,H2:H31)))

...confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

To list all days that are not Mondays...

I2:

=SUM(IF(H2:H31<>"",IF(WEEKDAY(H2:H31,2)>1,1,0)))

...confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

J2, copied down:
=IF(ROWS($E$1:E1)<=$I$2,INDEX($H$2:$H$31,SMALL(IF($H$2:$H$31<>"",IF(WEEKDAY($H$2:$H$31,2)>1,ROW($H$2:$H$31)-ROW($H$2)+1)),ROWS($E$1:E1))),"")

...confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

Hope this helps!

looks good many thnx ;-)