All, attached is a spreadsheet I have put together for my immediate manager in order for him to help manage his whole team's annual leave requirements.
One of our company's rules is that everybody is required to take a least 10 consecutive working days once per year.
My leave is detailed in column H and you will be able to see that I have 10 consecutive working days booked during the month of August.
What I would like add is a flag at the top of the sheet advising as follows;
No - the person has not yet booked 10 consecutive days
Booked - Yes the person has booked, but not yet taken
Yes - Yes booked and yes has taken
The sheet has a number of formula on already, it also has a number of conditional formatting, I do not mind adding as much formula as needed to work this out!
Would love to grant more than 500 points on this!