Get the integer valure from the current date

[Andrew Haycock]

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

 

[Ron de Bruin]

You can use the Weekday function in VBA code

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

 

[merjet]

Use the worksheet function Weekday().

HTH,
Merjet