Array Function & EDATE

[Harimau]

Hi all,

I'm trying to use an array function for EDATE. My current formula is as
follows:

EDATE($C$13:$D$13,$C$15:$D$15)

Where the values in row 13 are dates, and the values in row 15 are months.
It's part of a larger formula. When I evaluate this entire formula in the
formula bar using F9, it returns {#VALUE!, #VALUE!}.

However, if I evaluate each of the sections individually first, namely
"$C$13:$D$13" and "$C$15:$D$15", then evaluate the entire EDATE part, it
returns the correct results in numbers.

Even when I out that entire EDATE section and group it with a SUM function,
it still returns #VALUE! I've done the ctrl+Shift+enter, so its not that.

Can someone please help?

Thanks

Harimau

 

[Tyro]

Can't do much for you as you didn't show us your formula

Tyro

 

[T. Valko]

I don't think EDATE will return an array.

 

[Ron Rosenfeld]

Hi all,

I'm trying to use an array function for EDATE. My current formula is as
follows:

EDATE($C$13:$D$13,$C$15:$D$15)

Where the values in row 13 are dates, and the values in row 15 are months.
It's part of a larger formula. When I evaluate this entire formula in the
formula bar using F9, it returns {#VALUE!, #VALUE!}.

However, if I evaluate each of the sections individually first, namely
"$C$13:$D$13" and "$C$15:$D$15", then evaluate the entire EDATE part, it
returns the correct results in numbers.

Even when I out that entire EDATE section and group it with a SUM function,
it still returns #VALUE! I've done the ctrl+Shift+enter, so its not that.

Can someone please help?

Thanks

Harimau

Whether or not a function can return arrays or handle array inputs depends on
the function, and is not well documented by Excel.
--ron