How can I ask an application to do something each monday or first day of the
week...
is there a function First Day of the Week????
The first day of the week where I live is Sunday.
So if you wish to test if the current date is a Monday, (WeekDay #2),
you could use:
If WeekDay(Date())= 2 Then
' It's Monday
' Do Something
Else
' It's not Monday
' Don't do anything
End If
Sunday is weekday #1, .... Saturday is #7
Look up the WeekDay() function in VBA Help to learn how to set the
first day of the week to a different day.
