Find Jobs
Hire Freelancers

Excel Project - Compare Dates between Columns

$30-250 CAD

Closed
Posted over 1 year ago

$30-250 CAD

Paid on delivery
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.
Project ID: 34844276

About the project

76 proposals
Remote project
Active 1 yr ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
76 freelancers are bidding on average $116 CAD for this job
User Avatar
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 available almost 24-7 and am very responsive. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 Kindly contact me via chat for further details and discussion.. Thank you Sandeep
$180 CAD in 3 days
4.9 (587 reviews)
8.5
8.5
User Avatar
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 formulas and VBA (macros) to accomplish this. I'm among this platform's most experienced and skilled Office and VBA developers. I am particularly in the top 1% of freelancers, I have completed over 650 projects successfully in 9 years, and I feel confident in achieving your task. I will charge you $150* and deliver within a couple of days (we can discuss the milestones; I don't require any payment in front). I'm online from 8 am to 9 pm, Athens time (including weekends) (10 pm - 11 am Pacific time). I'm looking forward to working with you. Sincerely, Paris Pallas *My quote is indicative and may change after discussing the tasks needed in detail.
$150 CAD in 2 days
5.0 (584 reviews)
8.6
8.6
User Avatar
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 employers have left me in the following link: https://www.freelancer.com/u/elqueabandona Contact me to discuss the details. Cheers
$150 CAD in 4 days
5.0 (339 reviews)
7.5
7.5
User Avatar
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 Queries, Pivot Tables and Excel based formulas. Lets discuss your project in detail and how I am highly suitable for this.
$40 CAD in 1 day
4.8 (218 reviews)
7.2
7.2
User Avatar
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 days
4.8 (313 reviews)
7.4
7.4
User Avatar
Hi. I have written many automation Excel projects. Ready to write your project. Will complete within 1 day
$120 CAD in 1 day
4.9 (274 reviews)
6.8
6.8
User Avatar
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 Flow Chart, Excel Cash Flow, Excel Balance Sheet, Excel Waterfall Model, Excel Forecasting Models, Excel Prediction Models, Forecasting, Excel ROI, Excel Financial Ratio analysis, Investment, -> Financial modelling and projections, Cash flow, Balance Sheet, Trial Balance, -> Business valuation, Financial reports, Business analysis, Income Tax, Tax Return -> Economic research & analysis of Big.
$30 CAD in 7 days
4.9 (145 reviews)
7.0
7.0
User Avatar
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 macros.
$100 CAD in 3 days
4.9 (129 reviews)
6.6
6.6
User Avatar
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 Excel, data entry and are fluent in English. Hit us up and we can talk in detail Regards, Nikita and her team at Affiliazion (V)
$149 CAD in 7 days
5.0 (51 reviews)
6.6
6.6
User Avatar
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 days
4.9 (203 reviews)
6.8
6.8
User Avatar
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 get your job done in a very short time. Look forward to hearing back from you. Regards Romany
$150 CAD in 2 days
4.8 (73 reviews)
6.4
6.4
User Avatar
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 to Friday) and also create another table by month. We can discuss further details over chat. Please check my reviews for quality of work and client satisfaction. Looking forward to working with you. Thanks, Hamid
$70 CAD in 1 day
5.0 (90 reviews)
6.1
6.1
User Avatar
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 discuss your project in more details. Thanks, Virendra
$90 CAD in 3 days
4.8 (147 reviews)
6.2
6.2
User Avatar
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 years of experience, therefore, I can easily do this job. You can message me to discuss the detail and make sample for you. ---------------------- Mohamed A. ----------------------
$100 CAD in 1 day
4.9 (162 reviews)
6.1
6.1
User Avatar
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 projects. It will be my pleasure discussing your requirements in details. Fee is slightly negotiable. Looking forward, Abdul
$250 CAD in 10 days
4.8 (67 reviews)
6.4
6.4
User Avatar
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 experienced data processing professionals will complete the task as per your requirements (after a final mutual discussion and understanding). They will be supported by other professionals from our team if current requirements necessitate some advanced skills, as our whole team comprises but is not limited to the following. • Professionals in Data Entry. • Experts in Data and Web Automation. • Microsoft.Net Development Professionals. • DevOPs. • Python • And others (on-demand). We are not new to business and have already established credibility. More importantly, we value the time and trust of our clients. We are looking forward to hearing from you to level up and expedite your business benefits. Regards and best wishes for your professional endeavors.
$250 CAD in 20 days
5.0 (9 reviews)
5.6
5.6
User Avatar
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 trust to me. Result will be excellent Best Regards
$78 CAD in 1 day
5.0 (62 reviews)
5.4
5.4
User Avatar
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 knowledged in Google Sheet Script coding and formula You can select me because I have done similar project and some of them are attached in my profile. https://www.freelancer.com/u/rameshraja86 1. I can develop Excel/Google Sheet formulas using IF, VLOOKUP, HLOOKUP, MATCH, SUM, COUNT, AVERAGE, SUMIFS, and all other Functions 2. I can create any VBA/Script coding to automate the calculations in Excel, Word and PowerPoint also in Google Sheet. 3. I can integrate Outlook and Excel to get the mail details and send mails automatically. Also I can send mails via Google Sheet automatically. 4. I can extract data from PDF, Word automatically using VBA 5. I can store the pulled data in any form (csv, txt, pdf, excel) or in MySQL database 6. I can create Excel, Word, PDF files automatically with the defined template. 7. I have done project in Excel to develop custom Excel Addin for Chart templates with automatic formatting 8. I have done project in Excel to create Addin for word automation which will search for library words and highlight wherever present in the document. 9. I have done project to pull data or download data from website using Selenium VBA and IE-VBA (Web Scrapping) Thank you for taking the time to read my application
$200 CAD in 1 day
5.0 (40 reviews)
5.4
5.4
User Avatar
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 in 2 days
5.0 (11 reviews)
5.0
5.0
User Avatar
Hi, Project is 80 percent ready please message me to get it now. we need to discuss also. Thanks.
$39 CAD in 1 day
4.9 (65 reviews)
5.0
5.0

About the client

Flag of LEBANON
Beirut, Lebanon
5.0
4
Payment method verified
Member since Aug 22, 2016

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.