Get the integer valure from the current date

  • Thread starter Thread starter Andrew Haycock
  • Start date Start date
A

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
 
You can use the Weekday function in VBA code

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