variable date in XIRR function possible?

M

mstroop

The XIRR function has a format of XIRR(values, dates, 0.1). I'd like to
write the formula so that it refers to start and end dates specified in
two user-entry cells so that only values and dates within the date
range are included in the XIRR output.

This can easily be done by manually changing the included values and
dates ranges but this is quite tedious. Is there a way to match the
dates provided in two user cells across the entire date range to
identify the desired value and date ranges without editing the XIRR
formula?

I wonder if variable formulas are more the province of MS Access. I'm
open to all suggestions.


Thanks, Matthew
 

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

Similar Threads

Can XIRR Work on Dates That Move Backwards in Time? 3
XIRR Function 1
XIRR vs. IRR Function 11
XIRR Requiring Sale Price > 0 2
XIRR - Automating the date range 0
XIRR function in Excel 2007 2
XIRR non contiguous references 2
How to write XIRR formula on excel using different Year basis than 365. 5

Top