Display text if date is on weekend AND holiday

[meganisagee]

Hi everyone,

I currently have a formula which identifies when an application date is on a weekend and when it is on a holiday. When it's a weekend, it says "Application date is a weekend." When it's a holiday, it says "Application date is a holiday." However, if the date happens to be a weekend AND a holiday (such as 1/1/2023), both conditions are met and it displays "Note: Application date is a weekend.Note: Application date is a holiday."

I'd like to combine the formulas so if the application is on a weekend, holiday, or happens to be on both, the text will display "Note: Application date is a weekend/holiday."

Here's what I have (note the beginning is if the field is blank, it doesn't show anything):

Thanks in advance.

 

[Peter_SSs]

Try

=IF(AND(D2<>"",OR(WEEKDAY(D2,2)>5,COUNTIF(Holidays!$C$2:$BJ$14,D2))),"Note: Application date is a weekend/holiday","")

 

[meganisagee]

Ah, it worked! Thank you so much.

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.