Kapalı

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.

Beceriler: Excel, Veri Girişi, Veri İşleme, Visual Basic, Excel Macros

Müşteri Hakkında:
( 4 değerlendirme ) Beirut, Lebanon

Proje NO: #34844276

Bu iş için 78 freelancer ortalamada $116 teklif veriyor

(873 Değerlendirme)
9.2
(371 Değerlendirme)
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 Daha Fazla

$180 CAD in 3 gün içinde
(565 Değerlendirme)
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 Daha Fazla

$150 CAD in 2 gün içinde
(517 Değerlendirme)
8.4
(570 Değerlendirme)
8.0
(163 Değerlendirme)
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 Daha Fazla

$150 CAD in 4 gün içinde
(336 Değerlendirme)
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 Daha Fazla

$150 CAD in 2 gün içinde
(241 Değerlendirme)
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

$100 CAD in 4 gün içinde
(308 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% CAD
(189 Değerlendirme)
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 Daha Fazla

$30 CAD in 7 gün içinde
(128 Değerlendirme)
6.9
writingapp

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% CAD
(241 Değerlendirme)
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

$50 CAD in 2 gün içinde
(195 Değerlendirme)
6.8
(113 Değerlendirme)
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 Daha Fazla

$100 CAD in 3 gün içinde
(125 Değerlendirme)
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 Daha Fazla

$149 CAD in 7 gün içinde
(48 Değerlendirme)
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 Daha Fazla

$150 CAD in 2 gün içinde
(73 Değerlendirme)
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 Daha Fazla

$90 CAD in 3 gün içinde
(146 Değerlendirme)
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 Daha Fazla

$250 CAD in 10 gün içinde
(66 Değerlendirme)
6.3
(13 Değerlendirme)
5.7