Need Help With Formula

[noel1]

01/01/2023

02/01/2023

03/01/2023

04/01/2023

05/01/2023

06/01/2023

07/01/2023

08/01/2023

09/01/2023

10/01/2023

11/01/2023

12/01/2023

13/01/2023

14/01/2023

15/01/2023

16/01/2023

17/01/2023

18/01/2023

19/01/2023

START

END

DAYS

MO

TU

WE

TH

FR

SA

SU

MO

TU

WE

TH

FR

SA

SU

MO

TU

WE

TH

FR

01/01/2023

19/01/2023

14

=-AND(E$1>=$B4,E$1<=$C4)
The formula above fills in the cells which are within the range of the dates but I do not know how to exclude Saturday and Sunday from the formula.
=-AND(E$1>=$B4,E$1<=$C4,TEXT(E$1,"ddd")<>"SA",TEXT(E$1,"ddd")<>"SU")
this is a formula which I got from chat open ai but it doesn't seem to work
Ant help would be great

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W
1					01/01/2023	02/01/2023	03/01/2023	04/01/2023	05/01/2023	06/01/2023	07/01/2023	08/01/2023	09/01/2023	10/01/2023	11/01/2023	12/01/2023	13/01/2023	14/01/2023	15/01/2023	16/01/2023	17/01/2023	18/01/2023	19/01/2023
2		START	END	DAYS	MO	TU	WE	TH	FR	SA	SU	MO	TU	WE	TH	FR	SA	SU	MO	TU	WE	TH	FR
3		08/01/2023	19/01/2023	14
4		01/01/2023	19/01/2023	14
Master

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
E3:W4	Expression	=-AND(E$1>=$B3,E$1<=$C3,WEEKDAY(E$1,2)<6)	text	NO

 

[noel1]

Thanks. Fluff. that helped my son out on his planner scheduler..poor lad spent 3 hrs on chat last night..

Also, that Vstack...if you would like to repost that for any estimators on the platform..they would benefit I'm sure.

 

[Fluff]

What vstack?

 

[noel1]

the formula you hlped me with originally...(vstack with the little v1 ref....

 

[Fluff]

I have not used VSTACK on this thread.