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?

  • 1
    you want WORKDAY. support.office.com/en-us/article/… – Alex M Feb 13 at 19:46
  • Hey @Anonymous,, you mean to say that you want to highlight all weekdays for the month except Weekend or except Weekends & Holidays !! – Rajesh S Feb 14 at 7:48

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.