A Anonymous May 18, 2004 #1 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????
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????
F fredg May 18, 2004 #2 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???? Click to expand... 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.
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???? Click to expand... 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.
J John Smith May 18, 2004 #3 Thank you very much for your help! fredg said: 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. Click to expand...
Thank you very much for your help! fredg said: 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. Click to expand...
