I need to get the start and end dates of the holidays for the upcoming 3 months only of the person selected in cell M3 drop down list (Tab “Start end”).
- Calendar is in tab ‘’Calendar”
- Start and end dates needed only if person has consecutive 5 days or more away from work. Days away from work can include “va”-vacation,”bh”-Bank holiday and weekends (Saturday/Sunday).
- “BT”-Business trip, “S”-Sick and “F”- flow is not considered as days away from work.
80 KB Views: 4