Sub test()
dys = Format(Date, "dddd")
MsgBox "Today is " & UCase(dys)
End Sub


On Feb 1, 10:04*pm, Savio wrote:
Any idea how to use VBA code to check if the current day is a
particular day ?
example : check if today is saturday
thanks