Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date Question
I have a macro that shoots me a reminder if today is Friday. Is it possible
to specify if today is the first weekday of the month? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date Question
Select Case Weekday(Date(),2) ' Monday=1, ... Sunday=7
Case 1 If Day(Date())<4 Then Call Alert() ' If Monday the 1st, 2nd or 3rd must be 1st day of month Case 2 To 5 If Day(Date())=1 Then Call Alert() ' Any other weekday, only if 1st of month End Select Alert() would be a sub used to alert you -- - K Dales "StephanieH" wrote: I have a macro that shoots me a reminder if today is Friday. Is it possible to specify if today is the first weekday of the month? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date Question
Thanks K.
"K Dales" wrote: Select Case Weekday(Date(),2) ' Monday=1, ... Sunday=7 Case 1 If Day(Date())<4 Then Call Alert() ' If Monday the 1st, 2nd or 3rd must be 1st day of month Case 2 To 5 If Day(Date())=1 Then Call Alert() ' Any other weekday, only if 1st of month End Select Alert() would be a sub used to alert you -- - K Dales "StephanieH" wrote: I have a macro that shoots me a reminder if today is Friday. Is it possible to specify if today is the first weekday of the month? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
DATE question | Excel Worksheet Functions | |||
DATE Question | Excel Worksheet Functions | |||
DATE Question | Excel Discussion (Misc queries) | |||
Another Date Question | Excel Discussion (Misc queries) | |||
date question | Excel Programming |