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! -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Book1.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet