Getting Business Days to work within my formula

[Vincent Thank You]

Good morning,

I am a new user here although I have been using your results via Google for quite some time. I've got a formula that I'm using to highlight past due dates, 2 days past due. I'd like to be able to highlight 2 days past due, business days only. I seen several formulas including WORDAY but I can't seem to get any of them to work within my formula. I'm excited to be here, hopefully I have followed all the rules and I can contribute in the future as well.

 Columns("I:I").Select
    Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlLess, _
        Formula1:="=TODAY()-2"
    Selection.FormatConditions(Selection.FormatConditions.Count).SetFirstPriority
    With Selection.FormatConditions(1).Font
        .Color = RGB(255, 0, 0)
        .TintAndShade = 0

 

[RoryA]

Welcome to the forum.

For Workdays, you would need:

Formula1:="=WORKDAY(TODAY(),-2)"

 

[Vincent Thank You]

Welcome to the forum.

For Workdays, you would need:

Formula1:="=WORKDAY(TODAY(),-2)"

Hey RoryA!

Thank you very much. I must of tried every possible version of that formula except the correct one, thank you. Below is the corrected formula used to highlight dates 2 Business Days past due for Column I, red:


Columns("I:I").Select
Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlLess, _
Formula1:="=WORKDAY(TODAY(),-2)"
Selection.FormatConditions(Selection.FormatConditions.Count).SetFirstPriority
With Selection.FormatConditions(1).Font
.Color = RGB(255, 0, 0)
.TintAndShade = 0