I want to create a rule in conditional formatting to highlight all dates that are within 6 business days.
The best I could come up with is
=AND(L1>TODAY(),L1<=(TODAY()+6)). The problem with this formula is that it includes weekend dates. I want a formula that counts dates that are only weekdays.
What formula do I use?