Using EDATE with arrays as arguments

[Jody Wally]

I have a conditional sum array formula where as one of
the conditions, I am trying to use the EDATE function
with arrays as arguments. However, I keep getting
the "#VALUE!" error.

The function looks like: EDATE(Range1,Range2), where
Range1 is a named range of valid dates and Range2 is a
named range of numeric values (1-36) that represent
months.

Notes:
-The Range1 date values are all valid and the EDATE
function resolves them correctly with the Range2 argument
when the formulas use straight references and not arrays.
-The full array formula functions correctly until I add
the EDATE condition.
-The named ranges are dynamic ranges, which function
correctly elsewhere on the sheet.

My tentative conclusion is that the EDATE function cannot
use arrays as arguments, but I haven't been able to
verify this anywhere, so I am hoping that there is some
other explanation, since I don't want to build the
condition the long way.

So, can EDATE use arrays as arguments? If so, why am I
getting the error?

Thanks Experts!

Jody

 

[akyurek]

EDATE does not return an array, just a scalar. Try to eplace the EDATE
expression with one using DATE.