Week Wise Stored Procedure

WHERE MONTH(value_col) = @monthparam AND YEAR(value_col) = @yearparam

Should Replaced with,After Replacing it works

WHERE MONTH(date_col) = @monthparam AND YEAR(date_col) = @yearparam

thanks it was helpful for reference.But what if there are values not present for complete month in that case date range logic fails.What should i do