I've just found this works if you change the date to a number format and
use the corresponding number in the formula. THis column could then be
hidden next to a column with the correct date in it.
I would still be interested in any solutions other than this.
P.s - on general Multiple criteria stuff i found this link useful:
http://www.j-walk.com/ss/excel/tips/tip74.htm
--
chris100
------------------------------------------------------------------------
chris100's Profile:
http://www.excelforum.com/member.php...o&userid=25166
View this thread:
http://www.excelforum.com/showthread...hreadid=386956