Between dates in vba

[choubix]

hello,

In a sub I have the following code:


For Each rCl In wsStart.Range("G1:G" & _
wsStart.Range("G" & Rows.count).End(xlUp).Row)
If rCl.Value = Date + 5 Then


the sub only looks at data that is 5 days after today.
actually it would be better for me to look at data from today to the next 5 days.

can someone tell me how to handle this case please??

thx

[david000]

For Each rCl In wsStart.Range("G1:G" & _
wsStart.Range("G" & Rows.count).End(xlUp).Row)
If rCl.Value <= Date + 5 Then

[Ago]

For Each rCl In wsStart.Range("G1:G" & _
wsStart.Range("G" & Rows.count).End(xlUp).Row)
If rCl.Value => Date And rCl.Value <= Date+5 Then

[choubix]

thx! works like a charm!

[mdmackillop]

Don't forget to mark your questions Solved.