I am currently having an issue using the DateSerial function in vba. When a date with the 31st day of a month is input as a variant/string type a Type Mismatch error occurs. This only happens with the 31st day of the month. All other dates work.Is there another way to convert a variant/string to a variant/date?
