Hi Dackson,
I am still not understanding what you are after.
Instead of me trying to decipher your worksheet, can you describe what you are trying to achieve? That will ensure we are formulating a proper solution that addresses all of your requirements.
The following is what I have understood so far, but there are many gaps in my understanding.
-Sajan.
- You are looking to track the "leave" days and "work days" for people
- Are you looking to track this for just one month, or multiple months?
- As input, you will have the specific dates when folks will be on "leave" (assuming that they are working on all other days)
- You want to see those "leave" dates and "working" days visually represented, in aggregate. (i.e. this display is not per person.)
- You also want to see the total number of "leave" days and total number of "working" days. Is that by month, or aggregate across all months?
- What else are you trying to do?
I am not sure I understand what you mean by "changes Blue background data". what do you mean by that?
- You are looking to track the "leave" days and "work days" for people - Yes (people not important - any one)
- Are you looking to track this for just one month, or multiple months? - Single month September only.
- As input, you will have the specific dates when folks will be on "leave" (assuming that they are working on all other days) Yes
- You want to see those "leave" dates and "working" days visually represented, in aggregate. (i.e. this display is not per person.) ok
- You also want to see the total number of "leave" days and total number of "working" days. Is that by month, or aggregate across all months? ok
I am not sure what you are asking here. The calculations already take into account leave that spans multiple days vs a single day.Please considered continue leave and single day leave