MsgBox Weekday(Date)
MsgBox Format(Date, "dddd")

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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