I manually populated the spreadsheet by dragging the formula to the bottom. In this instance, I would use the Construction Start Date and the Operations End Date, but either way I don't know how to build a macro to populate down a spreadsheet with dates like the example I provided. Sorry if the other fields added confusion, don't worry about the other fields, I am only interested in start and end populating down in rows and auto stopping when it reaches the Operations End Date. Thanks!