Format if date is more than 5 working days

[Geek Girl 007]

I want O2 to go red if O2 is more than 5 working days.
This is the formula I used, but it didn't work

=NETWORKDAYS.INTL(TODAY(),O2,1)<=5

 

[Geek Girl 007]

10/8/2024 shouldn't be red it is only 5 working days from today, you specified more than 5 working days and is a Saturday

Oh dear lord, Sunday, working from home brain, so so sorry, yes I put in the 9th and it worked.
Thank you so much!

 

[Geek Girl 007]

If I got you right, you are looking for a formula with 6 working days (monday to saturday) and only sunday as weekend.

Is this working for you?

Book1
	A	B
1	Date logged	Days
2	17/08/2024	1
3	05/08/2024	12
Sheet1

Cell Formulas
Range	Formula
B2:B3	B2	= NETWORKDAYS.INTL(A2,TODAY(),11)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:A3	Expression	= NETWORKDAYS.INTL(A2,TODAY(),11) <= 5	text	NO

Thank you, no it was just me being to tired and not seeing what was in front of me.

 

[MARK858]

yes I put in the 9th and it worked.
Thank you so much!

You're welcome, happy we could help