In Excel,
=weekday(today())
would tell you the day of week with 1 being a Sunday.

In VBA, you can use
Weekday(Now())
to return the day of the week.

- Chirag

PowerShow - View multiple PowerPoint slide shows simultaneously
http://officeone.mvps.org/powershow/powershow.html

"Savio" wrote in message
...
Any idea how to use VBA code to check if the current day is a
particular day ?
example : check if today is saturday
thanks