You can use the WeekDay function. It returns 1 for Sunday and 7 for Saturday.
msgbox WeekDate(Now)
>Hello.
>
>I need a way to find out if a specific date falls on a weekend or on a regular week day.
>
>Can somebody tell me what is the easiest way to do it?
>
>Thanks
>
>Nick
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com
