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

 

[hagia_sofia]

Hello, would this work for you:

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

 

[Geek Girl 007]

Hello, would this work for you:

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

Sorry, I just tried it with different dates, and it is only working at 5 days, not working days???

 

[PeteWright]

bump... already solved

 

[MARK858]

Sorry, I just tried it with different dates, and it is only working at 5 days, not working days???

Works for me (shouldn't have the equals sign though if greater than 5 working days)

Book1
	O	P
2	17/08/2024	Saturday
3	05/08/2024	Monday
4	06/08/2024	Tuesday
5	07/08/2024	Wednesday
6	08/08/2024	Thursday
7	09/08/2024	Friday
8	10/08/2024	Saturday
9	11/08/2024	Sunday
10	12/08/2024	Monday
11	13/08/2024	Tuesday
12	14/08/2024	Wednesday
13	15/08/2024	Thursday
14	16/08/2024	Friday
Sheet1

Cell Formulas
Range	Formula
P2:P14	P2	=O2
O4:O14	O4	=O3+1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
O2:O14	Expression	=NETWORKDAYS.INTL(O2,TODAY(),1)>5	text	NO

 

[Geek Girl 007]

Works for me (shouldn't have the equals sign though if greater than 5 working days)

Book1
	O	P
2	17/08/2024	Saturday
3	05/08/2024	Monday
4	06/08/2024	Tuesday
5	07/08/2024	Wednesday
6	08/08/2024	Thursday
7	09/08/2024	Friday
8	10/08/2024	Saturday
9	11/08/2024	Sunday
10	12/08/2024	Monday
11	13/08/2024	Tuesday
12	14/08/2024	Wednesday
13	15/08/2024	Thursday
14	16/08/2024	Friday
Sheet1

Cell Formulas
Range	Formula
P2:P14	P2	=O2
O4:O14	O4	=O3+1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
O2:O14	Expression	=NETWORKDAYS.INTL(O2,TODAY(),1)>5	text	NO

Maybe because it's a Sunday and I shouldn't be working, but I can't work out what I'm missing?
So sorry

 

[MARK858]

Don't know where you are getting the 8 from

Book1
	O	P
2	17/08/2024	0
3	05/08/2024	10
4	06/08/2024	9
5	07/08/2024	8
6	08/08/2024	7
7	09/08/2024	6
8	10/08/2024	5
9	11/08/2024	5
10	12/08/2024	5
11	13/08/2024	4
12	14/08/2024	3
13	15/08/2024	2
14	16/08/2024	1
Sheet1

Cell Formulas
Range	Formula
P2:P14	P2	=NETWORKDAYS.INTL(O2,TODAY(),1)
O4:O14	O4	=O3+1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
P2:P14	Cell Value	>5	text	NO
O2:O14	Expression	=NETWORKDAYS.INTL(O2,TODAY(),1)>5	text	NO

 

[Geek Girl 007]

Don't know where you are getting the 8 from

Book1
	O	P
2	17/08/2024	0
3	05/08/2024	10
4	06/08/2024	9
5	07/08/2024	8
6	08/08/2024	7
7	09/08/2024	6
8	10/08/2024	5
9	11/08/2024	5
10	12/08/2024	5
11	13/08/2024	4
12	14/08/2024	3
13	15/08/2024	2
14	16/08/2024	1
Sheet1

Cell Formulas
Range	Formula
P2:P14	P2	=NETWORKDAYS.INTL(O2,TODAY(),1)
O4:O14	O4	=O3+1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
P2:P14	Cell Value	>5	text	NO
O2:O14	Expression	=NETWORKDAYS.INTL(O2,TODAY(),1)>5	text	NO

The 8 is a different format, that's the total number of days: =TODAY()-O2
I want the date formula to show up in column O

 

[MARK858]

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

 

[PeteWright]

If I got you right, you are looking for a formula with 6 working days (monday to saturday) and only sunday as weekend and he formula should count if there are less then 5 working days.

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