VBA: Using "<=" symbol with Countifs Function

Hello,

tried few variations to include "<=" symbol in ( Rngdate ) the following function..but could not succeed. Can someone assist please.. ( the below code works perfectly but it is comparing for an "Exact" Date match but i need to count number of instances "Less then" given date)

Please Login or Register  to view this content.

Note: Empname and Jdate are named ranges
Rngempname and Rngdate are VBA Variables
Expected Result: count "Jdate"s <= Rngdate

Tried...but "Error 2015"