Thanks for the response, but I think I do want to create a macro. I want the macro to auto-fill the end of month dates in rows. I would like to provide a start and end date and then have the macro automatically fill the number of rows needed based on a monthly end of month date. I started a spreadsheet and created an "Input" tab that would keep my variables and then for now I manually copied down my months to show how I would ultimately want it to look. Any help with the macro (including a button for someone to push) would be great! I've attached my spreadsheet I have started with.

Attached Files

Operation template.xlsx (52.2 KB, 20 views)