IRR formula with dynamic year range

It is possible. Rather than the ADDRESS() function, I would be inclined to use the OFFSET() function instead: https://support.office.com/en-us/art...e-b4d906d11b66 (hint: your COUNT() function goes in the "width" argument)

Sounds like OFFSET will do what you need - I'm getting confused by your cell references, though, so attach a sample workbook if you need a more specific answer!

You 'tweak' it exactly like any other formula, by passing the arguments required.

Example: with dates in Column A, Values in Column B, you might write something like:

Formula:

Please Login or Register  to view this content.

Now to adjust this for an 'unknown' number of dates / values, you might change it to something like:

Formula:

Please Login or Register  to view this content.

So if you are failing with your formula adjustments, then you're getting the OFFSET function wrong.

Why not post an (anonymized) example of your worksheet structure, and what you are trying, so that we can offer more meaningful examples?

Your OP suggests that your ranges are going across columns rather than down rows. However Olly's example should still work just fine, except you may need to switch the height and width arguments in his OFFSET() functions. Olly's example shows the COUNT() function in the height argument, where you may need it in the width argument.

It might help to see what you have tried. "too many arguments", especially when nesting functions multi-levels deep, is often indicating that you are not being careful about parentheses and commas/semicolon delimiting arguments, and syntax stuff like that. Look at the attempts you have tried and carefully count parentheses and make sure the opening and closing parentheses are all where they should be.

Try the following:

Formula:

Please Login or Register  to view this content.

Let us know if you have any questions.

You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools link above your first post. I hope that you have a blessed day.