Within cell progress bar for Working days?

[AEB12BAR]

Hi all,
I have to track my work on an excel spreadsheet, including keeping track of some tasks that are time sensitive. I recently discovered the NETWORKDAYS function to track working days, which I have been (using along with conditional formatting) to trigger the date I have input in the cell (Q5 in my example below) to change colour.
=AND(Q5<>''',NETWORKDAYS(Q5,TODAY())>10)
With this formula, whilst the cell changing colour once the 10 working days has elapsed has been helpful, I was thinking what would be even better if the cell were to change colour based on the no. of working days that have passed?
So in the case of the above formula, if 5 working days have passed - 50% of the cell would be highlighted, so basically a progress bar - and with the cell progressively highlighting further from the left to the right of the cell as each day passes, until it is 100% highlighted after 10 working days.

Is there any way this can be done?
Any help/pointers would be much appreciated

 

[felixstraube]

You can use a helper column R like this

The formula is the one you use:

Book1
	Q	R
5	1/1/2024	7
6	1/2/2024	6
7	1/3/2024	5
8	1/4/2024	4
9	1/5/2024	3
10	1/6/2024	2
11	1/7/2024	1
12	1/8/2024	0
Sheet1

Cell Formulas
Range	Formula
R5:R12	R5	=IF(Q5<>"",TODAY()-Q5,0)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
R5:R12	Other Type	DataBar		NO
R5:R12	Other Type	DataBar		NO

And set the conditional formatting to Data Bars and configure min and max values to 0 and 10:

 

[JamesCanale]

This is why I'm on here - learning. Stealing from Felix's idea:

MrExcelPlayground20.xlsx
	G	H
6	10 days ago	Today
7	12/30/2023	1/8/2024
8
9	1/1/2024
10	1/2/2024
11	1/9/2024
12	1/8/2024
Sheet21

Cell Formulas
Range	Formula
G7	G7	=H7-9

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
G9:G12	Other Type	DataBar		NO

EDIT - I have it backwards!

 

[JamesCanale]

This works better. I changed the color of the cells to blue, and made a reverse white bar.

MrExcelPlayground20.xlsx
	G	H
6	10 days ago	Today
7	12/30/2023	1/8/2024
8
9	12/30/2023
10	1/2/2024
11	1/5/2024
12	1/8/2024
Sheet21

Cell Formulas
Range	Formula
G7	G7	=H7-9

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
G9:G12	Other Type	DataBar		NO

 

[AEB12BAR]

Cheers both - this is great!
In playing around with the dates when using Felix’s suggestion, I notice when I input an even older date - it doesn’t stop at 10 and tracks the overall no. of working days which have passed, which is a handy added bonus!
Thanks again for all your help - it is much appreciated

 

[felixstraube]

Glad we could help. Thanks for the feedback!