Calculating a timeline between 2 dates

[Thembela01]

[TABLE="width: 500"]
<tbody>[TR]
[TD]Task

[/TD]
[TD]Start date
[/TD]
[TD]End Date
[/TD]
[TD]No of Days
[/TD]
[/TR]
[TR]
[TD]Preparation
[/TD]
[TD]Mon 30/07/218
[/TD]
[TD]Mon 06/08/2018
[/TD]
[TD]5
[/TD]
[/TR]
[TR]
[TD]Blueprint
[/TD]
[TD]Tue 07/08/2018
[/TD]
[TD]Tue 07/08/2018
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]Realisation
[/TD]
[TD]Wed 08/08/2018
[/TD]
[TD]Fri 10/08/2018
[/TD]
[TD]3
[/TD]
[/TR]
</tbody>[/TABLE]

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.