How do I count number of vacation days taken?
Posted on 2009-05-13
I have a basic attendance spreadsheet. It lists 30 employees time off, both actual and scheduled. I would like to add a column that lists the just actual vacation days taken off since the 1st of the year.
I have a summary sheet that lists all categories...(sick, late, vacation....etc) I'm only interested in actual vacation days taken.
Each month is listed and the for example the vacation category has this formula..
It will count all vacation days listed. Some may have pasted and some may be in the future. I need a count of only actual days taken from 01/01/09 thru now(). Not sure how to go about this.