Excel Project - Compare Dates between Columns

Lukket Lagt ut 1 år siden Betales ved levering
Lukket Betales ved levering

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 Dataregistrering Databehandling Visual Basic Excel Macros

Prosjekt-ID: #34844276

Om prosjektet

76 bud Eksternt prosjekt Aktiv 1 år siden

76 frilansere byr i gjennomsnitt $116 for denne jobben

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 Mer

$180 CAD på 3 dager
(587 Omtaler)
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 Mer

$150 CAD på 2 dager
(584 Omtaler)
8.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 Mer

$150 CAD på 4 dager
(339 Omtaler)
7.5
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 Mer

$40 CAD på 1 dag
(218 Omtaler)
7.2
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 på 4 dager
(313 Omtaler)
7.4
writingapp

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

$120 CAD på 1 dag
(274 Omtaler)
6.8
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 Mer

$30 CAD på 7 dager
(145 Omtaler)
7.0
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 Mer

$100 CAD på 3 dager
(129 Omtaler)
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 Mer

$149 CAD på 7 dager
(51 Omtaler)
6.6
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 på 2 dager
(203 Omtaler)
6.8
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 Mer

$150 CAD på 2 dager
(73 Omtaler)
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 Mer

$70 CAD på 1 dag
(90 Omtaler)
6.1
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 Mer

$90 CAD på 3 dager
(147 Omtaler)
6.2
ha4401310

I AM AVAILABLE RIGHT NOW ------------------------------------------------ Greetings! ----------------- I’m very much interested to your requirements and Job openings. I am a Professional in VBA Macro Excel with more ye Mer

$100 CAD på 1 dag
(162 Omtaler)
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 Mer

$250 CAD på 10 dager
(67 Omtaler)
6.4
sohailhost

Hi, this is Ahmed. Bidding Executive, SA Solutions Providers (Already Verified and Preferred Freelancers with good ratings and clientele feedback). We have read the project details and are confident that our experien Mer

$250 CAD på 20 dager
(9 Omtaler)
5.6
MamukaB

Hello I can help with this project. I have read explanation. Can do within few hours . Have some questions regarding details. I have 15+ year experience in Excel, Excel VBA, Python and have 100% feedback So, you can Mer

$78 CAD på 1 dag
(62 Omtaler)
5.4
rameshraja86

Hi There, I have understood your requirement for week end calculation in Excel. I can complete this is few minutes to hour. Let me introduce myself. I am a Excel developer with 13 years experience. I am equally kno Mer

$200 CAD på 1 dag
(40 Omtaler)
5.4
croll12

I can add the requested columns based on your criteria. I have over 15 years of experience in Excel and specialize in data analysis. Let’s discuss further.

$140 CAD på 2 dager
(11 Omtaler)
5.0
Peefect

Hi, Project is 80 percent ready please message me to get it now. we need to discuss also. Thanks.

$39 CAD på 1 dag
(65 Omtaler)
5.0