Excel to auto populate dates based on start and end
I would like to create a template using an excel spreadsheet where we can calculate monthly project costs.
1. I have provided the start date and the end date of the project.
2. I have provided the formula for the monthly cost.
I would like Excel to auto populate the end of month date beginning with my start date (by row) and to automatically stop when it reaches the end date.
How can this be done? Does this need to be a macro?
Thanks,
Pati Doherty
|