Weekday marking based on a date in during current week

[Deepakchoudhary]

Hi Friends,
I need help in attached sheet, where A1 is current date by =today(), B6 to P6 are dates of current month & B3 to P3 WEEKDAYS by =text(B6,"DDDDDD"), formula in B4 to P4 for marking "1" for the dates till yesterday by =IF(B6<$A$1,1,"") as month till date (MTD).
Need help in formula to put in cells from B5 to P5, to get mark as "1" from last Monday till Yesterday as week till date (WTD), rest will "blank".

 

[FormR]

Hi, here's one option you can try:

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	06/03/2024
2
3
4
5	WTD				1	1
6		01/03/2024	02/03/2024	03/03/2024	04/03/2024	05/03/2024	06/03/2024	07/03/2024	08/03/2024	09/03/2024	10/03/2024	11/03/2024	12/03/2024	13/03/2024	14/03/2024	15/03/2024
Sheet1

Cell Formulas
Range	Formula
B5:P5	B5	=IF(AND(B6>=WORKDAY.INTL($A$1,-1,"0111111"),B6<$A$1),1,"")

 

[Deepakchoudhary]

Hi, here's one option you can try:

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	06/03/2024
2
3
4
5	WTD				1	1
6		01/03/2024	02/03/2024	03/03/2024	04/03/2024	05/03/2024	06/03/2024	07/03/2024	08/03/2024	09/03/2024	10/03/2024	11/03/2024	12/03/2024	13/03/2024	14/03/2024	15/03/2024
Sheet1

Cell Formulas
Range	Formula
B5:P5	B5	=IF(AND(B6>=WORKDAY.INTL($A$1,-1,"0111111"),B6<$A$1),1,"")

Sir, Thanking you. Great help for me, it's working fine.