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

[halesowenmum]

Hi.

I have a spreadsheet with the following layout:

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]
[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Due date[/TD]
[TD]Today[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]15/11/2019[/TD]
[TD]=TODAY()<strike></strike>
[/TD]
[TD]Progress bar needed[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]24/12/2019[/TD]
[TD]=TODAY()<strike></strike>
[/TD]
[TD]

Progress bar needed​

<strike></strike>[/TD]
[/TR]
</tbody>[/TABLE]
<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.