I am an intermediate Excel user. I am looking for ideas/help on creating a worksheet using formulas and maybe macros to count how many Fridays and Saturdays a year an employee takes time off. I have attached a sample spreadsheet (my info). I have a spreadsheet (I created) like the attached for each employee. One of our policies is staff cannot take more than 4 Friday/Saturdays off a year. I am using QuickBooks software as my payroll software, but because the way we accrue leave time, I am not using QB but I am using Excel to keep up with accruals. If anybody has any thoughts or ideas I would appreciate them. Thank you in advance.