Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
If Conditional Expression based on day of week
- Thread starter meagain
- Start date
You may want to explore VBA Weekday Function and add to your macro some logic like:
---- Andy
There is a great need for a sarcasm font.
Code:
MsgBox Weekday(Date())
MsgBox WeekdayName(Weekday(Date()))
Select Case Weekday(Date())
Case 1, 2, 7 [green]'Sun, Mon, Sat
[/green]
Case Else [green]'All other days[/green]
End Select---- Andy
There is a great need for a sarcasm font.
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question