Using IF/And with Weekday Function to not include Holidays

[Hastings]

I am checking the date to make sure it is a weekday
I then check to see if the Task is equal to "no" if it is I return "problem" in the Result column
But I also need to make sure the date isnt a Holiday
How can I insure all conditions are addressed?

Thanks!

 

[Joe4]

Welcome to the Board!

Excel has a function called WORKDAY which also takes into account Holidays, to check to see if a certain date is a Workday or not.
See here for how to use it: Excel Formula: Check If Date Is Workday

 

[Fluff]

Hi & welcome to MrExcel.
How about

Fluff.xlsm
	I	J	K	L
1
2	problem		02/08/2023	no
3			03/08/2023	yes
4	problem		04/08/2023	no
5			05/08/2023	no
6			06/08/2023	no
7	problem		07/08/2023	no
8	problem		08/08/2023	no
9	problem		09/08/2023	no
Sheet6

Cell Formulas
Range	Formula
I2	I2	=IF(AND(WORKDAY(K2-1,1,$P$2:$P$10)=K2,L2="no"),"problem","")
I3:I9	I3	=IF(AND(WORKDAY(K3-1,1)=K3,L3="no"),"problem","")

Where P2:P10 is the holidays.

 

[Hastings]

Thanks Fluff works perfect!

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[Hastings]

On other thing.
What would I add to check if coulmn J has a value and L is eq="no" also flag as a problem?

 

[Fluff]

How about

=IF(AND(WORKDAY(K2-1,1,$P$2:$P$10)=K2,L2<>"",J2="no"),"problem","")

 

[Hastings]

Worked perfect!

 

[Fluff]

You're welcome.