Home » Blogs » Nick's blog

XLA Routines: EE_IsWeekend

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

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