dim d as date = "2015-01-05"d = d.AddMonths(-1)Dim d2 As Date = new Date(d.Year, d.Month, 27)
msgbox(d2)