Hi Aladin

Totally superfluous double unary minus "--". The multiplication alone
will coerce the True's and |False's to 1's and 0's.

I had used a formula to convert the source data from text to numeric,
and forgot to omit the double unary when amending the formula for
posting.

--
Regards

Roger Govier


"Aladin Akyurek" wrote in message
...
What does

*--

mean?

Roger Govier wrote:
Hi

I put my start date in F1 and my end date in G1 then the array
entered formula
{=MAX((A1:A14)*--(B1:B14=F1)*--(B1:B14<=G1))}
give the result.

To enter (or modify) an array formula, commit with
Control+Shift+Enter and not just Enter
Do not type the curly braces { } yourself, if you use
Ctrl+Shift+Enter, Excel will insert them for you.