In this post, we will see how to resolve Excel EOMONTH function on range using TRANSPOSE
Question:I noticed that if I try to use EOMONTH on more than one cell at a time on for instance:
If I use the following formula:
I get a #VALUE! Error.
If I was to transpose the range (and transpose back to the original state) it works without errors:
Could someone explain this behaviour?
PS same goes for EDATE()
Best Answer:The unary plus operator (+) is also sufficient to coerce an array return:
If you have better answer, please add a comment about this, thank you!