H
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
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