Excel Spreadsheet Extract Data

[brneyes91507]

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.

[#2]

You can try this formula and validate results. 

=SUM(IF(IFERROR(WEEKDAY(E3:E21),0)>=6,F3:G21,0))

This checks for weekday of Day/Month column.  Condition >=6 means  Fridays and Saturdays. 

This formula assumes that vacation dates are in E3:H21 range and first column has valid dates.    

Hope this will work for you !!