Time Off - add to calendar as individual Daily entries.
When exporting Schedule into excel for reporting, to easily count numbers of vacation, the simplest formula is to count number of VACATION entries in a row. Since an entry that is more than 1 consecutives days is added as 1 entry, all the following cells are blank. while they should be labeled as vacation as well.
This can be fixed by labeling each day individually or by changing the way the entry is added to the calendar.
Hope that clear enough...