IF AND Formula to differentiate day of week

[OfficeUser]

In cell A2 I have a start date. In Cell B2 I have and end date. In Cell D1:V3 I have dates from 9/1/20 to 9/19/20. I am using the following formula in cell D2: =IF(AND(D1>=$A$2,D1<=$B$2),"X","").

I am hoping for a way to say that I only want an "X" placed if the date is Monday-Friday. I thought using cell C2 and placing an "X" there could be a trigger but unsure how to do this. I have attached a screenshot. Can anyone lend some guidance on how to accomplish this? The ultimate end goal would be to have a trigger for Weekdays and another for Weekend days. Thanks for taking a look, much appreciated.

Note: The formula shown is in cell D2 and then I copied it across.

 

[Joe4]

You can use the WEEKDAY function with IF/AND formulas, checking to see if the WEEKDAY of the date in row 1 is between 2 and 6.
See: How to use the Excel WEEKDAY function | Exceljet

 

[OfficeUser]

You can use the WEEKDAY function with IF/AND formulas, checking to see if the WEEKDAY of the date in row 1 is between 2 and 6.
See: How to use the Excel WEEKDAY function | Exceljet

Thanks, I have been looking through this site trying to see how its done and how to adapt it, I'll keep reading. Thanks.

 

[Fluff]

How about

=IF(AND(D1>=$A2,D1<=$B2,WEEKDAY(D1,2)<6),"X","")

 

[OfficeUser]

Thanks, I have been looking through this site trying to see how its done and how to adapt it, I'll keep reading. Thanks.

The difficult part is figuring out how to add the WEEKDAY function with the AND as part of the formula, I don't see any examples.

 

[OfficeUser]

Thanks Fluff, that works as intended. Appreciate the guidance from both of you.

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[OfficeUser]

Glad we could help & thanks for the feedback.

Everyone here is great, one of the most pleasant forums for getting help.

 

[Joe4]

Everyone here is great, one of the most pleasant forums for getting help.

Thanks for the kind words.
We are always happy to hear that!