I'm working on some VBA to take some of the drudgery out of payroll. Public Function ThisFriday() As Date
ThisFriday = Date + 8 - Weekday(Date, vbFriday)
End Function
Public Function LastFriday() As Date
LastFriday = Date + 1 - Weekday(Date, vbFriday)
End Function I thought I needed to know [...] Read More...