ANSWERS: 1
  • Try this: Dim dt As Date dt = #1/9/2008# MsgBox Format(dt, "mmmm dd,yyyy") MsgBox Format(dt, "YYMM") & Weekday(dt) I haven't been able to drop the leading zero off of "08".

Copyright 2018, Wired Ivy, LLC

Answerbag | Terms of Service | Privacy Policy