Fermé

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.

Compétences : Excel, Saisie de Données, Traitement de Données, Visual Basic, Excel Macros

Concernant le client :
( 4 commentaires ) Beirut, Lebanon

Nº du projet : #34844276

78 freelances font une offre moyenne de 116 $ pour ce travail

(873 Commentaires)
9.2
(371 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 3 jours
(565 Commentaires)
8.5
paris2785

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 2 jours
(517 Commentaires)
8.4
(570 Commentaires)
8.0
(163 Commentaires)
7.5
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 4 jours
(336 Commentaires)
7.4
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 2 jours
(241 Commentaires)
7.1
fhasanbd

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 4 jours
(308 Commentaires)
7.3
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% CAD en 1 jour
(189 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 7 jours
(128 Commentaires)
6.9
writingapp

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% CAD en 1 jour
(241 Commentaires)
6.7
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 2 jours
(195 Commentaires)
6.8
(113 Commentaires)
6.4
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 3 jours
(125 Commentaires)
6.5
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 7 jours
(48 Commentaires)
6.3
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 2 jours
(73 Commentaires)
6.4
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 3 jours
(146 Commentaires)
6.1
caabdul

Greetings! Hope you are doing well and safe. I am Certified in Accounting and Finance, with 13 years of experience in accounting, financial programming and taxation. Please check my profile for feedback on similar Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 10 jours
(66 Commentaires)
6.3
(13 Commentaires)
5.7