even the date posted above would to vba be a real date, by implicit conversion

?day("31-Feb-12")
12