VBA countifs date less than today's date?

[completeexcelnoob]

Dear all,

I have a range filled with dates as such:

	A
1	Date
2	01/07/2015
3
4	01/08/2015
5	01/09/2015

<tbody>
</tbody>

I am planning to use Worksheetfunction.countifs to count the number of dates that are smaller than today's date as one criteria. In excel this would have been done with

=COUNTIFS(A2:A5,"<"&TODAY())

However, I can't for the life of me seem to replicate this in VBA (getting errors). What is also important is that cells with blank dates are not counted at all (i.e. false) as COUNTIFS does.

Many thanks in advance.

 

[Takae]

Like this?

Sub test()
Dim A As Long
A = WorksheetFunction.CountIf(Range("A:A"), "<" & Date)
Range("B1").Value = A
End Sub