Conditional Formating Current Week??

[The Jackal]

Hi,

I have searched for this answer but can't find a solution. I am using conditional formatting to highlight the current 7 days but it highlights Sunday to Saturday. I am in the uk and generally we start the week on Monday. Is there a way I can highlight the week starting on a Monday without adding another column with a load of numbers in it?

 

[Sergius]

Hello! If you use the WEEKDAY function, then the second argument to this function determines what day the week starts on.
=WEEKDAY(10.11.2024;2). "2" means the week starts on Monday.

 

[Joe4]

I think you may want to use the WEEKNUM function, which returns the week number to see if your date has the same week number as the current date.
Note that you can specify the start of the work week with the second argument in that function.
See: WEEKNUM function - Microsoft Support

 

[MARK858]

As Joe4 has stated, try weeknum. For Monday to Sunday try...

Book1
	A
1	Tue 01/10/2024
2	Wed 02/10/2024
3	Thu 03/10/2024
4	Fri 04/10/2024
5	Sat 05/10/2024
6	Sun 06/10/2024
7	Mon 07/10/2024
8	Tue 08/10/2024
9	Wed 09/10/2024
10	Thu 10/10/2024
11	Fri 11/10/2024
12	Sat 12/10/2024
13	Sun 13/10/2024
14	Mon 14/10/2024
15	Tue 15/10/2024
16	Wed 16/10/2024
17	Thu 17/10/2024
18	Fri 18/10/2024
19	Sat 19/10/2024
20	Sun 20/10/2024
21	Mon 21/10/2024
22	Tue 22/10/2024
23	Wed 23/10/2024
24	Thu 24/10/2024
25	Fri 25/10/2024
26	Sat 26/10/2024
27	Sun 27/10/2024
28	Mon 28/10/2024
29	Tue 29/10/2024
30	Wed 30/10/2024
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1:A30	Expression	=WEEKNUM(A1,2)=WEEKNUM(TODAY(),2)	text	NO