On Sun, 13 Apr 2008 17:39:00 -0700, Harimau
wrote:

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