Spreadsheet: 50075d1249476555-array-range-from-multiple-selections-rate-of-return-calculation
Sheet: Example 3

 | Transaction | Dollar | Fees & | 401k |  | Anualized | YTD
Date | Description | Amount | Interest | Total |  | Rate | Rate
2008-12-26 00:00:00 | Contribution | 129.84 | 0 | 129.84
2009-01-09 00:00:00 | Contribution | 129.84 | -0.52 | 259.16 |  | #N/A | #N/A |  | These formulas won't work because the first item in the first argument to XIRR needs to be the balance at the beginning of the year and the last value needs to be the negative of the ending balance. Same thing for the second argument with respect to the date.
2009-01-23 00:00:00 | Contribution | 259.68 | -19.18 | 499.66 |  | #N/A | #N/A
2009-02-06 00:00:00 | Contribution | 259.68 | 25.75 | 785.0899999999999 |  | #N/A | #N/A
2009-02-20 00:00:00 | Contribution | 259.68 | -82.69 | 962.0799999999999 |  | #N/A | #N/A
2009-03-06 00:00:00 | Contribution | 259.68 | -96.72 | 1125.04 |  | #N/A | #N/A
2009-03-20 00:00:00 | Contribution | 259.68 | 132.57 | 1517.29 |  | #N/A | #N/A |  | See Example 2 for clarification    The bold values are what are not in the same place in my real spreadsheet
2009-04-03 00:00:00 | Contribution | 259.68 | 144.13 | 1921.1 |  | #N/A | #N/A
2009-04-17 00:00:00 | Contribution | 259.68 | 54.17 | 2234.95 |  | #N/A | #N/A
2009-05-01 00:00:00 | Contribution | 259.68 | 39.35 | 2533.98 |  | #N/A | #N/A
2009-05-15 00:00:00 | Contribution | 259.68 | 20.16 | 2813.82 |  | #N/A | #N/A
2009-05-29 00:00:00 | Contribution | 259.68 | 144.18 | 3217.68 |  | #N/A | #N/A
2009-06-12 00:00:00 | Contribution | 259.68 | 90.99 | 3568.35 |  | #N/A | #N/A
2009-06-26 00:00:00 | Contribution | 259.68 | -91.34 | 3736.690000000001 |  | #N/A | #N/A
2009-07-10 00:00:00 | Contribution | 259.68 | -165.78 | 3830.590000000001 |  | #N/A | #N/A
2009-07-24 00:00:00 | Contribution | 259.68 | 434.58 | 4524.85 |  | #N/A | #N/A
2009-08-07 00:00:00 | Contribution | 259.68 | 11.2429423076923 | 4795.772942307692 |  | #N/A | #N/A
2009-08-21 00:00:00 | Contribution | 259.68 | 16.60075249260355 | 5072.053694800295 |  | #N/A | #N/A
2009-09-04 00:00:00 | Contribution | 259.68 | 13.13710894353948 | 5344.870803743835 |  | #N/A | #N/A
2009-09-18 00:00:00 | Contribution | 259.68 | 18.50147585911328 | 5623.052279602949 |  | #N/A | #N/A
2009-10-02 00:00:00 | Contribution | 259.68 | 15.04441173708713 | 5897.776691340036 |  | #N/A | #N/A
2009-10-16 00:00:00 | Contribution | 259.68 | 20.41538085463859 | 6177.872072194675 |  | #N/A | #N/A
2009-10-30 00:00:00 | Contribution | 259.68 | 16.96494178836618 | 6454.517013983042 |  | #N/A | #N/A
2009-11-13 00:00:00 | Contribution | 259.68 | 22.34255889455668 | 6736.539572877598 |  | #N/A | #N/A
2009-11-27 00:00:00 | Contribution | 259.68 | 18.89879082919168 | 7015.118363706791 |  | #N/A | #N/A
2009-12-11 00:00:00 | Contribution | 259.68 | 24.28310202821581 | 7299.081465735007 |  | #N/A | #N/A
2009-12-25 00:00:00 | Contribution | 259.68 | 20.84605122754425 | 7579.607516962551 |  | #N/A | #N/A
2010-01-08 00:00:00 | Contribution | 259.68 | 26.23710294333191 | 7865.524619905883 |  | #N/A | #N/A
2010-01-22 00:00:00 | Contribution | 259.68 | 22.8068159919819 | 8148.011435897865 |  | #N/A | #N/A
2010-02-05 00:00:00 | Contribution | 259.68 | 28.20465497041569 | 8435.896090868282 |  | #N/A | #N/A
2010-02-19 00:00:00 | Contribution | 259.68 | 24.78117877608251 | 8720.357269644364 |  | #N/A | #N/A
2010-03-05 00:00:00 | Contribution | 259.68 | 30.18585208723049 | 9010.223121731595 |  | #N/A | #N/A
2010-03-19 00:00:00 | Contribution | 259.68 | 26.76923388291706 | 9296.672355614513 |  | #N/A | #N/A
2010-04-02 00:00:00 | Contribution | 259.68 | 32.18078892328101 | 9595.023144537794 |  | #N/A | #N/A
2010-04-16 00:00:00 | Contribution | 259.68 | 28.79354165416928 | 9889.986686191964 |  | #N/A | #N/A
2010-04-30 00:00:00 | Contribution | 259.68 | 34.2345692983568 | 10190.39125549032 |  | #N/A | #N/A
2010-05-14 00:00:00 | Contribution | 259.68 | 30.85443126900495 | 10487.41568675932 |  | #N/A | #N/A
2010-05-28 00:00:00 | Contribution | 259.68 | 36.3025927618592 | 10789.88827952118 |  | #N/A | #N/A
2010-06-11 00:00:00 | Contribution | 259.68 | 32.92961327526564 | 11088.98789279645 |  | #N/A | #N/A
2010-06-25 00:00:00 | Contribution | 259.68 | 38.38495809044925 | 11393.5428508869 |  | #N/A | #N/A
2010-07-09 00:00:00 | Contribution | 259.68 | 35.01918679153157 | 11694.73203767843 |  | #N/A | #N/A
2010-07-23 00:00:00 | Contribution | 259.68 | 40.48176474580995 | 12001.38380242424 |  | #N/A | #N/A
2010-08-06 00:00:00 | Contribution | 259.68 | 37.12325162377621 | 12304.67705404802 |  | #N/A | #N/A
2010-08-20 00:00:00 | Contribution | 259.68 | 42.59311287939698 | 12613.44016692741 |  | #N/A | #N/A
2010-09-03 00:00:00 | Contribution | 259.68 | 39.24190827013335 | 12918.85207519755 |  | #N/A | #N/A
2010-09-17 00:00:00 | Contribution | 259.68 | 44.71910333722228 | 13229.74117853477 |  | #N/A | #N/A
2010-10-01 00:00:00 | Contribution | 259.68 | 41.37525792569728 | 13537.28643646047 |  | #N/A | #N/A
2010-10-15 00:00:00 | Contribution | 259.68 | 46.85983766467086 | 13850.31627412514 |  | #N/A | #N/A
2010-10-29 00:00:00 | Contribution | 259.68 | 43.52340248735624 | 14160.0096766125 |  | #N/A | #N/A
2010-11-12 00:00:00 | Contribution | 259.68 | 49.01541811135095 | 14475.19509472385 |  | #N/A | #N/A
2010-11-26 00:00:00 | Contribution | 259.68 | 45.68644455865947 | 14787.05153928251 |  | #N/A | #N/A
2010-12-10 00:00:00 | Contribution | 259.68 | 51.1859476359779 | 15104.40748691848 |  | #N/A | #N/A
2010-12-24 00:00:00 | Contribution | 259.68 | 47.86448745471782 | 15418.4419743732 |  | #N/A | #N/A
2011-01-07 00:00:00 | Contribution | 259.68 | 53.37152991129184 | 15737.98350428449 |  | #N/A | #N/A
2011-01-21 00:00:00 | Contribution | 259.68 | 50.05763520713863 | 16054.21113949163 |  | #N/A | #N/A
2011-02-04 00:00:00 | Contribution | 259.68 | 55.57226932900949 | 16375.95340882064 |  | #N/A | #N/A
2011-02-18 00:00:00 | Contribution | 259.68 | 52.26599256899453 | 16694.38940138964 |  | #N/A | #N/A
2011-03-04 00:00:00 | Contribution | 259.68 | 57.78827100481028 | 17018.34767239445 |  | #N/A | #N/A
2011-03-18 00:00:00 | Contribution | 259.68 | 54.48966501982693 | 17368.87053741427 |  | #N/A | #N/A
2011-04-01 00:00:00 | Contribution | 259.68 | 60.12301339874171 | 17731.84675081301 |  | #N/A | #N/A
2011-04-15 00:00:00 | Contribution | 259.68 | 56.95946952204504 | 18091.65942033506 |  | #N/A | #N/A
2011-04-29 00:00:00 | Contribution | 259.68 | 62.62497491654442 | 18457.1375952516 |  | #N/A | #N/A
2011-05-13 00:00:00 | Contribution | 259.68 | 59.47009167587093 | 18819.46088692747 |  | #N/A | #N/A
2011-05-27 00:00:00 | Contribution | 259.68 | 65.14428768551818 | 19187.45837461299 |  | #N/A | #N/A
2011-06-10 00:00:00 | Contribution | 259.68 | 61.99812514289111 | 19552.30969975589 |  | #N/A | #N/A
2011-06-24 00:00:00 | Contribution | 259.68 | 67.68107203761653 | 19922.8439717935 |  | #N/A | #N/A
2011-07-08 00:00:00 | Contribution | 259.68 | 64.5436906715929 | 20290.24086246509 |  | #N/A | #N/A
2011-07-22 00:00:00 | Contribution | 259.68 | 70.23544913930223 | 20663.32951160439 |  | #N/A | #N/A
2011-08-05 00:00:00 | Contribution | 259.68 | 67.10690984786135 | 21033.28962145226 |  | #N/A | #N/A
2011-08-19 00:00:00 | Contribution | 259.68 | 72.80754099733473 | 21408.95036244959 |  | #N/A | #N/A
2011-09-02 00:00:00 | Contribution | 259.68 | 69.68790510078705 | 21781.49146755038 |  | #N/A | #N/A