Array Function & EDATE

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
 
R

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top