Date Time - Determining if date falls on weekend
|
|
Description: Function returns True if date falls on a weekend
'Public Function IsWeekend(ByVal vntDate As Variant) As Boolean
Dim bResult As Boolean
If IsDate(vntDate) Then
If (WeekDay(vntDate) Mod 6 = 1) Then bResult = True Else bResult = False
Else
Err.Raise 13, "Type Mismatch, Must Be Date"
End If
IsWeekend = bResult
'End Function
| |
|
|
Back |
|
Index |
|
Return to home page |