Conditional Formatting Ignoring Weekdays

[FeignedInterest]

Hi All,

I've looked through Google and this forum but can't find an answer to this specific issue. Apologies if it was out there and I missed it. I'm not an expert by any means, my formulas may look convoluted.

I have columns like these where they highlight to different colors based on dates in other columns. I was successful using DATEDIF but then realized I need this to ignore the weekends.

I have tried the following formula and although Excel accepts it, it isn't ignoring the weekends. Also, I tried WORKDAY instead of WEEKDAY but it wasn't successful.

I greatly appreciate any help you can provide. Thank you.

 

[Phuoc]

Try this:

=WEEKDAY(E2,2)<6

 

[FeignedInterest]

Try this:

=WEEKDAY(E2,2)<6

Thank you for the quick reply. Do you know how I would get the DATEDIF function to work with that?

 

[Phuoc]

No, the result of DATEDIF ($E2,$S$2, "d") is the number of days, not Date, cannot be an argument of the WEKNUM function.

 

[Jeffrey Mahoney]

Use the AND function
=AND(WEEKDAY(E2,2)<6,DATEDIF($E2,$S$2,"d")>3)