Amedee,

I know Charles has suggested an alternative approach, but to get DMAX
working in your case I think you would need to have a table of all of the
unique dates, like so

Amt.........Amt.........Amt etc
01-Apr....07-Apr...........etc.

and then point at the relevant criteria.

For instance

=DMAX($A$1:$B$5,"Amt",INDEX($K$1:$L$2,0,MATCH(A2,$ K$2:$L$2,0)))

where K2:L2 is that extended criteria table.

--

HTH

Bob

"Amedee Van Gasse" wrote in message
...
On 7 apr, 17:29, "Bob Phillips" wrote:
Amedee,

Your array formula was checking the dates against $A13695, so you can
just
put =$A13695 in K2, that is what I did in my test, it does not have to be
a
static value (It could even be the result of a formula, i.e. an
expression).

Bob,

On row 2 the array formula is checking the dates against $A2.
On row 3 the array formula is checking the dates against $A3.
On row 4 the array formula is checking the dates against $A4.
...
On row 13695 the array formula is checking the dates against $A13695.

Does that mean that I have to enter an array formula in K2??
#confused...