Here in this code I put a condition, and if the condition is met, I subtract 2 days from the date in cell "Q". But i wanted to know if i can subtract two WORKDAYS, instead of normal days.

*It needs to use weekday function, because i use excel 2002, and it does not have workdayfunction.



If Range("AW" & rw).Value >= Range("Q" & rw).Value Then
Range("AZ" & rw).Value = Range("Q" & rw).Value - 2
Range("AZ" & rw).Select
With Selection.Interior
.ColorIndex = 35
.Pattern = xlSolid
End With