Check to see if date is = to Sunday

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

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
>
>