vacation code =2 (could also be a 1 for sick day, 3 for unpaid day etc.)
i want to count # of vacation days taken (per employee) and number of vacation days booked (per employee)
Right now I have each employee in their own row
Columns B through MR represent each day of the year
In column MS the header row is labeled Vacation days taken - for row 2 as an example I need this to be count if B1 - MR1 less than or = to today AND Row 2 = 2
In column MT the header row is labeled Vacation days booked - for row 2 as an example I need this to be count if B1 - MR1 = greater than today AND Row 2 = 2
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.