Закрыт

Excel Project - Compare Dates between Columns

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.

Навыки: Excel, Ввод данных, Обработка данных, Visual Basic, Excel Macros

О клиенте:
( 4 отзыв(-а, -ов) ) Beirut, Lebanon

ID проекта: #34844276

77 фрилансеров(-а) готовы выполнить эту работу в среднем за $115

(876 отзывов(-а))
9.3
(383 отзывов(-а))
8.9
schoudhary1553

Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 850 + Projects. I have 6 + years of the experience in same kind of projects. I am a Больше

$180 CAD за 3 дней(-я)
(573 отзывов(-а))
8.5
ParisPallas

Hi, there! My name is Paris, and I was glad to see you are looking for an Excel developer. I will develop an automated Excel workbook to calculate the week endings between 2 dates. I plan to use a combination of formul Больше

$150 CAD за 2 дней(-я)
(538 отзывов(-а))
8.5
(600 отзывов(-а))
8.1
(164 отзывов(-а))
7.6
elqueabandona

Hi, how are you?, my name is Cristian and I am Excel/VBA expert. I can write a macro that performs the calculation you want. The tool will be completely reusable. You can see my previous work and the comments that em Больше

$150 CAD за 4 дней(-я)
(338 отзывов(-а))
7.5
fhasanbd

Hello! I've read your project details carefully. I'm good at Excel.. I'm sure I can help you do this. Thanks

$100 CAD за 4 дней(-я)
(308 отзывов(-а))
7.4
daniyal3214

Hello, I will be glad to assist you with that. I am an advance level Excel expert holding years of experience in performing Data Analytics, Automation and various other calculations and analysis using VBA, Macro, Power Больше

$40 CAD за 1 день
(193 отзывов(-а))
7.1
aubrey03

I am an Excel, Power BI, Google sheets, Google scripts and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check my portfolio website here Больше

$150 CAD за 2 дней(-я)
(241 отзывов(-а))
7.1
ShakeelASESE

I am an expert in Excel Formula, Advance Excel, Excel VBA, Excel Power Query, Excel Integration, Excel Macro, Excel Data Entry, Excel Data Scrapping, Excel Dashboard and API Integration, Excel financial models, Excel F Больше

$30 CAD за 7 дней(-я)
(131 отзывов(-а))
6.9
finecodervw

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

$50 CAD за 2 дней(-я)
(197 отзывов(-а))
6.8
(121 отзывов(-а))
6.5
writingapp

Hi. I have written many automation Excel projects. Ready to write your project. Will complete within 1 day

$120 CAD за 1 день
(248 отзывов(-а))
6.7
SShtv

Hello! I'm interested in your project. Your task is clear to me and I am ready to solve it. I have extensive and successful practical experience in processing and analyzing data in Excel, including using formulas and m Больше

$100 CAD за 3 дней(-я)
(127 отзывов(-а))
6.6
NIKITALILA

Hi there, I can definitely help you with your Excel work. We can do a quick zoom meeting to understand your requirements better. We are a team of trained professionals with years of experience in Bookkeeping, MS Ex Больше

$149 CAD за 7 дней(-я)
(50 отзывов(-а))
6.4
romanyfahmy0

Hi, dear sir I read all project description and would like to assist in getting the exact data you want from the excelsheet attached. we can go and discuss more info in the chat box, please hire me for htis job and ge Больше

$150 CAD за 2 дней(-я)
(73 отзывов(-а))
6.4
hamidr2020

Hello, I am an Excel expert. I have read the detailed instructions and checked the attached file. I offer my services to compare dates between column stages and distribute the data in result tab by Week Ending (Monday Больше

$70 CAD за 1 день
(76 отзывов(-а))
6.0
(54 отзывов(-а))
6.2
vsprybhanu

Hi, I can develop Excel VBA Macro as per your requirements. I am experienced Data Analyst and Macro Developer and have done many similar projects. So, can do this job nicely. Ready to start please message me to di Больше

$90 CAD за 3 дней(-я)
(147 отзывов(-а))
6.2