In the attached excel file, I would like to get the Week endings between the following columns:
Columns Q to AN represent stages of a call ticket.
For example: Column Q represent the start date of stage DNQ 1 and Column R represent the end date of DNQ 1 and also Start Date of DNQ 2. .and so on.
I would like to know how many WEEK ENDINGS it took DNQ 1 (Column Q) to move to DNQ 2(Column2 Q) and display the result in Results tab.
Note: Week Endings should be calculated MONDAY TO FRIDAY.
Column Q and R are an example in my explanation, and this concept should apply from Column Q to AN
Purpose: Compare dates between column stages and distribute the data in result tab by Week Ending (M-F) and also another table by month.
77 фрилансеров(-а) готовы выполнить эту работу в среднем за $115
Hi, I am well versed with automation in Excel and can help with comparison of dates between columns and distribute the data by week ending as well as month. Looking forward to your response. Thanks