I always find myself having to look these up: Date Codes for the Format Function
d day of month: 1 to 31
dd day of month, two digits: 01 to 31
ddd weekday, short: Mon, Tue, Wed, etc.
dddd weekday, long: Monday, Tuesday, etc.
w day of the week: 1 to 7
ww week of the year: 1 to 53
m month: 1 to 12
mm month, two digits: 01 to 12
mmm month, short: Jan, Feb, Mar, etc.
mmmm month, long: January, February, etc.
q quarter of year: 1 to 4
yy year, two digits: 00 to 99
yyyy year, four digits: e.g. 1950, 2000, 2014
h hour: 0 to 23
hh hour, two digits: 00 to 23
n minute: 0 to 59
nn minute, two digits: 00 to 59
s second: 0 to 59
ss second, two digits: 00 to 59
DateFormatted = Format(MyDate,"mmddyyyy")