Excel Project - Compare Dates between Columns
Budget: $30 – $250 CAD
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.
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.