Why does eomonth not work

Advance Power BI Concepts!! Learn Power BI in Hindi!! Proud to be a Super User! Message 3 of 6. Does it have time?

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with Thanks. Message 2 of 6. Message 4 of 6.

In response to TIA. In date, you can add days without using dateadd. Message 5 of 6. Awesome, thanks a lot amitchandak. Message 6 of 6. Post Reply. Log in. Install the app. If you forgot your password, you can reset your password. JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding. You are using an out of date browser.

It may not display this or other websites correctly. You should upgrade or use an alternative browser. Thread starter awhiffin Start date May 6, Tags array eomonth. Joined May 6, Messages 2. Hello, The folllowing function is not working. Excel Facts. Click here to reveal answer. The best answers are voted up and rise to the top.

Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Learn more. Ask Question.

Asked 3 years, 9 months ago. Active 3 years, 9 months ago. Viewed 1k times. Improve this question. Add a comment. Active Oldest Votes. Microsoft simply decided to not extend all formulas to work with arrays.

Improve this answer. Aganju Aganju 9, 3 3 gold badges 19 19 silver badges 39 39 bronze badges. The answer is not as simple as 'not working with arrays': EOMONTH actually works fine with array literals as input for either parameter, e. However, when the array comes from a sheet reference, it returns VALUE, suggesting some internal processing quirk. Did you read to the end, Govert?

It clearly states: "works with arrays, but not with ranges" — Aganju. You're completely right - I definitely did not see the last paragraph. Thank you for pointing that out - I now see the "- -" story too which is the most wonderful workaround and indeed works perfectly.