Lawrence429
New Member
Hello --
I am trying to build an XIRR workbook for different amounts of time. What I would like to do is enter a start date and a finish date and have a table created with all the dates inclusive between the two. So if I enter for example, 1 Sep '19 to 1 Dec '36 it would automatically create a column with 1 Sep '19 at the top and the first of each month up to and including 1 Dec '36 (if necessary I can cap the input to 30 years or something). I know I can grab the bottom right corner and drag it down but I am trying to make this as quick and easy as possible.
I am trying to build an XIRR workbook for different amounts of time. What I would like to do is enter a start date and a finish date and have a table created with all the dates inclusive between the two. So if I enter for example, 1 Sep '19 to 1 Dec '36 it would automatically create a column with 1 Sep '19 at the top and the first of each month up to and including 1 Dec '36 (if necessary I can cap the input to 30 years or something). I know I can grab the bottom right corner and drag it down but I am trying to make this as quick and easy as possible.