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

Tyro

"Harimau" wrote in message
...
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