Find Jobs
Hire Freelancers

Date Range - Excel Formula Creation.

£10-20 GBP

Closed
Posted over 8 years ago

£10-20 GBP

Paid on delivery
Create a formula that can assess start and end date ranges and how many days in a given month are covered by the supplied date ranges. It should also be able to highlight any date ranges that overlap one another.
Project ID: 8942561

About the project

35 proposals
Remote project
Active 8 yrs 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
35 freelancers are bidding on average £16 GBP for this job
User Avatar
Hello Sir, I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of Excel Formulas and VBA. I am an Engineering Graduate with an MBA degree. If you see I am among niche bidders who have zero failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done. Also I will provide you with a sample work before you consider awarding me the project. Thanks, Jay
£20 GBP in 1 day
5.0 (197 reviews)
6.9
6.9
User Avatar
Hi, I have more than 14 years of VBA/Excel exp and I am expert in this kind of work. I have completed more than 260 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
£19 GBP in 2 days
4.9 (76 reviews)
5.9
5.9
User Avatar
A proposal has not yet been provided
£20 GBP in 1 day
5.0 (53 reviews)
5.7
5.7
User Avatar
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best regards
£18 GBP in 0 day
4.9 (76 reviews)
5.9
5.9
User Avatar
Hello I can get this task done in the next 2 to hours. do let me know if you are interested. Thanks
£15 GBP in 0 day
5.0 (74 reviews)
5.5
5.5
User Avatar
I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. I have great experience in any kind of data manipulation with Excel/VBA. I have a solution ready for you using only Excel built in functions (no macros/VBA) in several helper columns which can be hidden if necessary.. I can send it to you immediately if you open a chat. Regards
£18 GBP in 1 day
4.9 (57 reviews)
5.7
5.7
User Avatar
Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 50 projects, almost 45+ are complex VB/VBA projects, hence i can definitely deliver an excellent solution to your requirement. Expert in VB/.NET, SQL, MS Office, Access/Excel/Word, Database, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex excel VBA projects, viz converting Raw data to structured using vba, sales dashboard, PO tracking, budgeting, profitability, estimation, time management dashboards, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers. Also Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis, Software development, Software Testing, SDLC, Budgeting, estimation, Project management, Process re-engineering, Statistics, Bookkeeping, HR, Payroll, AR/AP, copy typing, ebook creation, publishing, Web research, Social media marketing, lead generation, etc. Looking forward to work with you.. Have a nice day Thanks.
£16 GBP in 0 day
4.9 (40 reviews)
5.1
5.1
User Avatar
Hi. Your job seems to be fitting to my skillset. (I'm quite good at excel formulas) Excel is my legs and arms. I can make any reporting, formulas, pivot tables, macros etc. Just drop me a message so that we can discuss further.
£19 GBP in 1 day
5.0 (60 reviews)
5.3
5.3
User Avatar
Hello, I am Excel and VBA expert. I can complete this project using macro. Please note that I have 100% completion rate and 5-star feedback on projects.
£14 GBP in 1 day
5.0 (23 reviews)
4.6
4.6
User Avatar
A proposal has not yet been provided
£18 GBP in 1 day
4.9 (28 reviews)
4.3
4.3
User Avatar
Hi, I already download your attachment. For cell D12 how you get 8days? Should be 33days right, because is different month. And I not sure how to calculate overlap, can you kindly explain? I'm very well-verse in spreadsheets and Microsoft Excel, particularly strong in Formulas, V-Lookups, Pivoting, conditional formating, filtering and sorting.I also develop Professional Dashboards for Corporates with thier themes & SME as well. All work is delivered with high quality standards, without errors.I'm lookinQg forward to serve you, on your available task.
£19 GBP in 1 day
4.6 (31 reviews)
4.3
4.3
User Avatar
Dear client, I have a lot of experience with VBA and Excel. Send me a message for more information. Looking forward to work with u. Kind regards, Rens Slenders SlenDATA
£20 GBP in 1 day
5.0 (12 reviews)
3.9
3.9
User Avatar
Hello. My name is Brent. I am an Excel VBA expert. I can quickly set up a macro to work out the day values for you and apply the overlap logic. Available to start immediately.
£19 GBP in 2 days
4.9 (19 reviews)
3.9
3.9
User Avatar
Hi There, I have checked the attached file and i will create the formula in the excel using VBA, so that if anybody remove it by-mistake then it will not be removed. I can do it this job in quick turn around time. I am expert in EXCEL and VBA and created many software in VBA for various business processes. Kindly message me to discuss further. Thanks, Mufaddal
£13 GBP in 1 day
4.9 (18 reviews)
4.0
4.0
User Avatar
can do it in a minutes can do it in a minutes can do it in a minutes can do it in a minutes can do it in a minutes can do it in a minutes can do it in a minutes can do it in a minutes can do it in a minutes can do it in a minutes
£18 GBP in 3 days
5.0 (5 reviews)
3.4
3.4
User Avatar
Hi, I will be able to it. I have 3 years of experience in excel. I understand your requirements thanks, Arpan
£15 GBP in 1 day
4.9 (10 reviews)
2.8
2.8
User Avatar
Hello, I am interesting to your project & placed bid for your consideration. with my experiences in excel coder & formulas I am very confident that i will deliver good result as per your requirement on time. Appreciate If you would like to talk thru PM before awarding this project. Hope to hear from you soon Thank & Regards, gsanggara
£14 GBP in 1 day
5.0 (7 reviews)
2.6
2.6
User Avatar
A proposal has not yet been provided
£10 GBP in 3 days
5.0 (3 reviews)
2.4
2.4
User Avatar
I've been working with Excel for more than 10 years. I completed advanced training in the software when I worked at Microsoft. I worked using Excel in companies such as Shell and Microsoft
£10 GBP in 1 day
5.0 (2 reviews)
0.8
0.8
User Avatar
Dear Sir/Madam, I like to build EXCEL formulas to perform data analysis. I also used vlookup, pivot tables to perform data analysis as well. I am a very result and detail-oriented person. I would try my best to solve any kind of problem. Look forward to hear from you soon. Cheers, Cal
£16 GBP in 2 days
5.0 (1 review)
0.8
0.8

About the client

Flag of ISLE OF MAN
London, Isle of Man
0.0
0
Payment method verified
Member since Oct 18, 2015

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.