Task date calculator help

[Rococopops]

I need to create a way in excel to project the date when a milestone needs to be completed.

For example:

Start date = 1 June

End Date = 1 July



Let us say there are 5 milestones that need to be completed within this date range.

Start date = 1 June

Milestone 1

Milestone 2

Milestone 3

Milestone 4

Milestone 5

End Date = 1 July



Each milestone needs a date, but because date ranges can vary, I need to put a value to each milestone in days or using percentage.

In this example, there are 30 days between start and end dates



Start date = 1 June = 0% / Day 1

Milestone 1 = 10%

Milestone 2 = 20%

Milestone 3 = 40%

Milestone 4 = 60%

Milestone 5 = 80%

End Date = 1 July = 100% / Day 30



I know that milestone 5 needs to be completed by 80% of the way, which in this example is 24 days (80% of 30 days), this means milestone 5 should show 24 June as a result because it is 24 days after the start date.



Any suggestions on how I can create an excel that would give me a result like this?

 

[Rococopops]

Example layout

 

[BobUmlas]

Move the start and end dates to their own column so you have nothing in between them aside from blanks. That is, say June 1 is in B1 and July 1 is in B7. Select B1:B7, and set to General format (temporary), then use Fill/Series and notice that the right spacing is already put in by Excel:

Then click OK and change the format back to Date:

 

[CA_Punit]

Book1
	A	B	C
1	Start Date	01/06/2020
2	End Date	01/07/2020
3	Days Between	30
4
5	Task	Weight
6	M1	10%	03/06/2020
7	M2	20%	06/06/2020
8	M3	40%	12/06/2020
9	M4	60%	18/06/2020
10	M5	80%	24/06/2020
Sheet1

Cell Formulas
Range	Formula
B3	B3	=B2-B1
C6:C10	C6	=$B$1+$B$3*$B6-1

Is this you want??

 

[Rococopops]

THANK YOU BOTH FOR THIS!
CA_Punit I was able to use your formula to design the task calculator was needed using your example.