Checking to see if a date is within current month from a column of date values using vba

Hi,

I have a date input by the user......call-it "currentdate".

I want to compare this "currentdate" to a column of dates (say colA) in the following manner.
We would make this comparison to EACH date in column-A.


If month of current date = month of date in col-A AND year of currentdate = year of date in col-A then assign value of "valid" to an array.

This comparison ensures that the date in column A is in the same month if you will as the "currentdate"

I tried the month and year functions but if the value in col-A is not a date then i get a runtime error.

any ideas?

your correct.........i will have to use that function "isdate".

What i decided to do is take the user input date and create two new dates based on the user date: The first-of-th-month and end-of-month dates. THen take dates from col-A and make sure its between the first and end of months.

but i will still probably have to use the "isdate" function to make sure the value in col-a is not blank or something other than a date.

thanks.