Find Jobs
Hire Freelancers

Excel formula -- 3

€8-30 EUR

Completed
Posted over 1 year ago

€8-30 EUR

Paid on delivery
Hi, I need help to prepare an excel formula to know the number of days between two dates of a project for each different month of the year. All days of all projects belonging to that month must also be added up. So I have a sheet with an overview of the projects with start and end date and as a result of the formula I want to know for the next 12 months how many days of project I have in total for each month.
Project ID: 35410650

About the project

59 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
Awarded to:
User Avatar
€0 EUR in 1 day
5.0 (72 reviews)
5.4
5.4
59 freelancers are bidding on average €20 EUR for this job
User Avatar
Hello, I am an Excel formula expert and I can help you right away. Please send me a message so that we can discuss more.
€30 EUR in 1 day
5.0 (502 reviews)
8.0
8.0
User Avatar
Hello I am a proficient chartered accountant (C.A.) in business and finance analysis. I have 18 years’ experience as a practicing CPA and 20 years’ experience as an academic researcher and analyst. I am passionate about this project having gone through the instructions. I have 520+ reviews on related projects and the responses are positively overwhelming. I hold an MBA (Strategic Management), Bachelors of Commerce (Finance and Accounting) & C.P.A. (Certified Public Accountant.) Regards, Charles.
€29 EUR in 5 days
4.8 (89 reviews)
6.4
6.4
User Avatar
I can do it. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from this platfrom give me a chance to show you the best i can do at your service.
€30 EUR in 1 day
4.7 (158 reviews)
5.8
5.8
User Avatar
Hi, I am Sondip Moral..Data entry expert.. I have Good knowledge about excel formulas and functions.. I can complete your job perfectly as your requirement.. Please let me know Please contact me lets discuss over chat even the price.. I can do your job with in your budget.. waiting for your response.. Thank you. Sondip.
€10 EUR in 1 day
4.9 (17 reviews)
4.0
4.0
User Avatar
hello sir, i generally understood the project, please accept my bid so we can discuss in more details. Best Regards
€100 EUR in 3 days
5.0 (5 reviews)
4.0
4.0
User Avatar
Ho there I am a mechanical engineer and i work with excel in my day to day tasks. I have read your project description and what you are looking for is a pretty straight forward formula. Contact me so we can discuss the detail. I available to start working on your project first thing in the morning. Best regards Petar
€30 EUR in 7 days
5.0 (7 reviews)
3.7
3.7
User Avatar
Hi there, I am Computer literate and knowledge using Microsofts and fast typing and having experience admin clerks and it will finished as soon as possible. Could you please share the draft as it is now? I'm happy to guide you depending on your needs. Proficient in Microsoft Office (Microsoft Word, Excel and Powerpoint). Can do tasks accurately and fast. This is straightforward work! I can promise you great work right now! Just leave me a message to discus more about it. Thanks, Fius Mun.
€25 EUR in 1 day
5.0 (3 reviews)
3.3
3.3
User Avatar
Hi I am Vikram, read the project description - to know the number of days between two dates. I can help you for this excel related work. Please message me to discuss more. Regards, Vikram
€10 EUR in 2 days
4.9 (26 reviews)
3.1
3.1
User Avatar
Hello there, I am an excel specialist. I can competently help you get an excel formula to know the number of days between two dates of a project for each of the 12 months of the year. I am skilled and have hands-on experience in advanced excel formulas and functions. I am very savvy in excel calculations. I have done tasks involving advanced excel formulas and functions (I have samples if you require them). I do excellent work and pay utmost attention to details. I go the extra mile required to give clients 100% job satisfaction. Willing to work strictly within your budget. At your service. Nosakhare E.
€30 EUR in 2 days
5.0 (2 reviews)
2.9
2.9
User Avatar
Hello, sir! I have read your requirement and I noticed that I am appropriate to this project. I have rich experience with data processing using Excel formula and VBA. All clients call me "Princess of Excel". I promise I will finish this project with high quality on time. I hope you to contact me so that we have a full discuss with the project. Best regard!
€30 EUR in 1 day
5.0 (2 reviews)
2.1
2.1
User Avatar
Hi, You need a formula that calculates the number of workdays between 2 dates for all projects for each month. Off the top of my head I already figured a way to calculate the formula for each month by referencing the end date in your "simulation" worksheet inside your already created formula that calculates "Dynamics". It should look something like that =SUM(NETWORKDAYS('Sales Contractes (market)'!G8,Simulation!C17,workdays!$F$6:$F$15)). Of course this sometimes could give you negative numbers, but you can add an if condition to place a zero if you get a negative number. As for the calculating for each category junior, medior, and senior, I'd like to discuss the possibility of adding some hidden helper columns or even hidden worksheets that will aid us with our formula or even we can discuss creating a custom excel formula using VBA. If you have the time we can chat and discuss how to move forward.
€10 EUR in 2 days
5.0 (1 review)
1.1
1.1
User Avatar
Hello I work with this kind of excels the whole day. I can do it for you simple and clean hope to have news from you
€25 EUR in 3 days
5.0 (1 review)
0.6
0.6
User Avatar
Dear Sir, I have 3 years of practical experience in this work, if you give me the work then I can do your work. Thank You Ropak Barmon
€19 EUR in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi there, Looked at your job post and I am experienced with the task you've mentioned. Let's discuss more over chats. Regards, Marialyn
€28 EUR in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
You will be able to edit your bid until the project is awarded to someone. Bid Amount € 19.00 EUR This project will be delivered in 3 Days Paid to you: €19.00 - €4.00 fee = €15.00
€19 EUR in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello Future Client, I read project description carefully, I did several projects using Microsoft Excel. I’m a Data Analyst. I will my pleasure to helping you to prepare an excel formula to know days between two dates. Let me chat to discuss your timeline and instructions. Best wishes, Fatimah Asiri
€19 EUR in 7 days
5.0 (1 review)
0.0
0.0
User Avatar
Hello I am an accountant and data analyst. so I can help you in this case Please contact me to discuss this further Thank you Khaled Mohamed Ali
€20 EUR in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I need help to prepare an excel formula to know the number of days between two dates of a project for each different month of the year. All days of all projects belonging to that month must also be added up. So I have a sheet with an overview of the projects with start and end date and as a result of the formula I want to know for the next 12 months how many days of project I have in total for each month.
€20 EUR in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi sir how are you? Iam a data entry expert of 4 years of experience for hich project ican work for you plzzz inform me!!!
€19 EUR in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Client, I'm writing to express my interest in this position. I am fresh graduate and six years in university. I read through the job details extremely carefully and I am absolutely sure that I can do the project very well. We can discuss about the duration and price for this project. I look forward to discuss with you soon. I would love to work on your project. Thank you. Sincerely, Freelancer Siti Maisarah
€19 EUR in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of BELGIUM
Antwerp, Belgium
5.0
2
Payment method verified
Member since Oct 10, 2020

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) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
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.