Calculating a timeline between 2 dates

[Thembela01]

Task	Start date	End Date	No of Days
Preparation	Mon 30/07/218	Mon 06/08/2018	5
Blueprint	Tue 07/08/2018	Tue 07/08/2018	1
Realisation	Wed 08/08/2018	Fri 10/08/2018	3

<tbody>
</tbody>

Hi Gurus,

In the absence of Microsoft Project, i'm trying to make a timeline based on the start and end date of the task.The timeline based on the dates should show at column number 5

Thanks,
T.

 

[Special-K99]

Use Conditional Formatting.

Place the ascending dates in a row starting at E1 up to the last date you want.

Select row 2 from column E to the last column you want.

Select Conditional Formatting
New Rule
Use a formula to determine...

=AND(E$1>=B2,E$1<=C2)

Format as required
Use Format painter (paintbrush icon) to copy to other rows and change the colour of the cell presumably.

 

[Thembela01]

Thank you. But I have weeks on E1 on my first row which makes it a bit harder. Its as follows

Jul 30|Aug6|Aug13|Aug|20

 

[Special-K99]

Your weeks on E1 ARE ascending dates (assuming they are dates and not text).
Are they dates or text?


Did you try what I suggested?

 

[Thembela01]

My start date and end date are texts. I need to change it date, its because of the "DDD" for the days of the week that excel will be unable to calculate.