Ditutup

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.

Kemahiran: Excel, Pemasukan Data, Pemprosesan Data, Visual Basic, Excel Macros

Tentang Klien:
( 4 ulasan ) Beirut, Lebanon

ID Projek: #34844276

77 pekerja bebas membida secara purata $115 untuk pekerjaan ini

(876 Ulasan)
9.3
(383 Ulasan)
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 Lagi

$180 CAD dalam 3 hari
(573 Ulasan)
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 Lagi

$150 CAD dalam 2 hari
(538 Ulasan)
8.5
(600 Ulasan)
8.1
(164 Ulasan)
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 Lagi

$150 CAD dalam 4 hari
(338 Ulasan)
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 dalam 4 hari
(308 Ulasan)
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 Lagi

$40 CAD dalam sehari
(193 Ulasan)
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 Lagi

$150 CAD dalam 2 hari
(241 Ulasan)
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 Lagi

$30 CAD dalam 7 hari
(131 Ulasan)
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 dalam 2 hari
(197 Ulasan)
6.8
(121 Ulasan)
6.5
writingapp

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

$120 CAD dalam sehari
(248 Ulasan)
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 Lagi

$100 CAD dalam 3 hari
(127 Ulasan)
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 Lagi

$149 CAD dalam 7 hari
(50 Ulasan)
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 Lagi

$150 CAD dalam 2 hari
(73 Ulasan)
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 Lagi

$70 CAD dalam sehari
(76 Ulasan)
6.0
(54 Ulasan)
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 Lagi

$90 CAD dalam 3 hari
(147 Ulasan)
6.2