You can use the Weekday function in VBA code

Sub test()
MsgBox Application.WorksheetFunction.Weekday(Now, 1)
End Sub



--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Andrew Haycock" wrote in message om...
Hi,

How do i get the integer value for the current day.

I know i need to use the sysdate and then perform some action on that
to tell me the integer representation of the day.

eg SUNDAY = 0
MONDAY = 1
etc.

Please any help is much appriciated