Time used in-cell bar - today's date compared to due date

[halesowenmum]

Hi.

I have a spreadsheet with the following layout:

	H	I	J
	Due date	Today
5	15/11/2019	=TODAY()<strike></strike>	Progress bar needed
6	24/12/2019	=TODAY()<strike></strike>	Progress bar needed​ <strike></strike>

<tbody>
</tbody>

<strike></strike>

1. What formula do I need in J5 and J6
2. What CF do I need in J5 and J6

Progress bar would show how much time the person had used - they could then compare this to the % progress they enter elsewhere on the sheet to see if they look on track based on the time remaining to complete the item.

Thank you.

 

[pbornemeier]

You also need the start date so you can get a percentage time used with a formula like: (DueDate-Now)/(DueDate-StartDate). Then format that cell using DataBars.