I need some help with a code to the workbook uploaded. I'm having a hard time in finding a way to start!
The workbook is to control day works of employes where they cannot work more than 183 days in the last 365 continuous days.
I need a code where based on the selected cell it shows me anywhere in the sheet how many days the employe worked in the last 365 days and how many days off he had, this way it will be possible to plan how many days I can use someones work without extrapolate the limit easyer then counting manually every time I need to do that.
E= work
F= day off
V= trip (same as work)
If some arrangement need to be done to make the code easier its ok.
I started thinking in using a countif, but i didint know how to make count works backwards 365 days based on the selected cell.
Then now i'm trying to use a matrix and array to store the values then based on the cell, but i'm also having trouble in make it work on the 3 years range as shown on the file uploaded.
Thank You all,
Sorry for my bad english, I'm trying to improve!
Bookmarks