Ok, I am trying to create a custom variable with data pulled from other variables but I can't get excel to accept it. I keep getting a type mismatch but can't figure out how to get past it
Can anyone tell me how to combine the found month and year into the new variable? Is there any easier way to get the date without a value in the day field?
Public StartDate As Date StartDate = "11/1/2010" Dim Month As String Month = DatePart("M", StartDate) Dim Year As String Year = DatePart("YYYY", StartDate) Dim MonthYear As Date MonthYear = Month & "/" & "*" & "/" & Year