Auto Populate Date and Text based on calculated fields

Good afternoon,

As part of a resource management tool I am creating in excel, I would like to define the resource demand by months and phase of the project.
In doing this, my goal is to have the cells auto populated with the following:

- The start of the Project as defined in a field (Cell B9 in attached example)

- Fill the number of cells as defined for the specific phase (s) from a calculated field - Ex Assessment Phase would be 1.8 (cell E3 in attached example) so I would like the 2 cells auto populated, Align is 1 month (cell E4 in attached example), so auto populate 1 cell, Engage is 7 months (cell E5 in attached example), populate 7 cells etc...

- Have each cell populated with the appropriate month based on phase and starting of project. Ex Project Assessment phase starts 1/2020 and runs 1.8 months. So 2 cells, labeled with 1/2020 and the second with 2/2020 (cell H2:I2 in attached example). Next is the Align phase which lasts 1 month, so 1 cell labeled 3/2020, Engage is 7 months, so 7 cells labeled 4/2020, 5/2020, 6/2020 etc..

- On the row below the dates, have cells populated and merged with the corresponding Phase name Ex Assessment (cell H3:i3 in attached example) - Not sure this is possible

Thank you in advance for any assistance or comments.

I agree with the calculation. Is it possible to split the cells to show both phases with in a single cell? I am not sure how this would look visually.
The other option is to round up, this level of accuracy would be acceptable for this part of the workbook.
Is it possible to extend the calculations out to consider projects greater then 13 months?

Thank you

Hemesh,

Good morning, I am hoping you can assist me in resolving an issue I am encountering. I will have a raw data sheet within my resource workbook and want to call the data fro the formula from that data (pretty straight forward). However, once I apply the formula to the new worksheet data, I receive a #Value error.

I have attached the sample spreadsheet with my references for your review.

In addition, I am curious on how I would resolve one of my original questions related to the auto date generation. Here is my original ask for your reference.

- Have each cell populated with the appropriate month based on phase and starting of project. Ex Project Assessment phase starts 1/2020 and runs 1.8 months. So 2 cells, labeled with 1/2020 and the second with 2/2020 (cell H2:I2 in attached example). Next is the Align phase which lasts 1 month, so 1 cell labeled 3/2020, Engage is 7 months, so 7 cells labeled 4/2020, 5/2020, 6/2020 etc..

Thank you for your assistance.

Thank you. However, I am changing the formula to call the info from another tab. Applying the formula and changing the reference data to that tab is causing the #Value error.

If I can resolve that, then I would be able to copy and paste.

Any thoughts on how to remove the error?