Home

CHALLENGE

%3CLINGO-SUB%20id%3D%22lingo-sub-918378%22%20slang%3D%22es-ES%22%3EChallenge%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-918378%22%20slang%3D%22es-ES%22%3E%3CDIV%20class%3D%22user-mention-tag%22%3E%3CP%20class%3D%22user-mention-tag-label%22%3E%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%20class%3D%22user-mention-tag-label%22%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%3B%20Help%20me%20with%20this%2C%20which%20is%20a%20real%20challenge.%20On%20Sheet1%20I%20have%20the%20distribution%20of%20hours%20on%20different%20days%20that%20last%202%20activities%20for%20each%20group.%20There%20are%20some%20days%20that%20do%20not%20work%20(apart%20from%20Sundays).%20On%20Sheet2%20I%20need%20two%20things%3A%20THE%20FIRST%20one%20that%20automatically%20calculates%20the%20percentage%20of%20progress%20of%20each%20group%20from%20the%20sum%20of%20hours%20from%20the%20start%20date%20to%20the%20current%20date%20(this%20is%20always%20changing).%20The%20second%2C%20that%20in%20SHEET2%20show%20the%20non-working%20dates.%20I%20attached%20the%20file.%20Thank%20youall.%3C%2FP%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-918378%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EFormulas%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Regular Visitor

@Ed Hansberry 

@Sergei Baklan

 

Please; Help me with this, which is a real challenge. On Sheet1 I have the distribution of hours on different days that last 2 activities for each group. There are some days that do not work (apart from Sundays). On Sheet2 I need two things: THE FIRST one that automatically calculates the percentage of progress of each group from the sum of hours from the start date to the current date (this is always changing). The second, that in SHEET2 show the non-working dates. I attached the file. Thank you all.