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)
Public Function LastFriday() As Date
LastFriday = Date + 1 - Weekday(Date, vbFriday)
I thought I needed to know this Friday (pay check day), but I actually need last Friday (end of pay period).