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

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

I don't think EDATE will return an array.

--
Biff
Microsoft Excel MVP


"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

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