VBA Code to Indentify Weekdays and Weekends

[mm3904]

Hello - I would like to use a VBA that generates a "true" when a date falls on a weekend and a "false" signal if it is a weekday. I tried some of the codes listed online but none seemed to work properly. Any thoughts?

 

[Luke M]

Something like this should work:

[pre]

Dim MyDate as Date
MyDate = Date 'Set this equal to today's date
If Weekday(MyDate, vbMonday) > 5 Then
'it's a weekend
Else
'it's a weekday
end if

[/pre]

 

[mm3904]

Great, thanks.