just change
VB Code:
  1. MsgBox Format(#5/30/2005#, "dddd mmmm dd, yyyy")
to

VB Code:
  1. MsgBox Format(#5/30/2005#, "mmmm dd, yyyy")

"dddd" means that he has to display the name of the day