Home » Blogs » Nick's blog

XLA routines: EE_IsWeekday

Nick's picture
Submitted by Nick on 31 January, 2015 - 08:39
EE_IsWeekday is a function that takes a date, and returns whether it is a weekday. 
Function EE_IsWeekday(dt As Date) As Boolean
'Takes a date, returns if it's a weekday
'http://excelexperts.com/xla-routines-eeIsWeekday    for updates on this function

    Select Case Format(dt, "w")
        Case vbSaturday, vbSunday
            EE_IsWeekday = False
        Case Else
            EE_IsWeekday = True
    End Select
End Function
»