You could probably use the WEEKDAY function.

"Brian" wrote:

I want to prompt the user if the date he entered is not a Sunday. It
might not be the Sunday in the current week but any Sunday. Is this
possible in VBA?


Thanks in advance

Brian