Find Jobs
Hire Freelancers

Excel formula -- 3

€8-30 EUR

Teljesítve
Kiadva ekkor: több mint 1 évvel ezelőtt

€8-30 EUR

Teljesítéskor fizetve
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.
Projektazonosító: 35410650

A projektről

59 ajánlat
Távolról teljesíthető projekt
Aktiválva: 1 évvel ezelőtt

Szeretne pénzt keresni?

A Freelancer oldalán történő árajánlatadás előnyei

Határozzon meg költségvetést és időkeretet
Kapja meg fizetését a munkáért
Vázolja ajánlatát
Ingyen regisztrálhat és adhat árajánlatot munkákra
Neki odaítélve:
Felhasználó avatár
€0 EUR 1 napon belül
5,0 (72 értékelés)
5,4
5,4
59 szabadúszó adott átlagosan €20 EUR összegű árajánlatot erre a munkára
Felhasználó avatár
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 1 napon belül
5,0 (502 értékelés)
8,0
8,0
Felhasználó avatár
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 5 napon belül
4,8 (89 értékelés)
6,4
6,4
Felhasználó avatár
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 1 napon belül
4,7 (158 értékelés)
5,8
5,8
Felhasználó avatár
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 1 napon belül
4,9 (17 értékelés)
4,0
4,0
Felhasználó avatár
hello sir, i generally understood the project, please accept my bid so we can discuss in more details. Best Regards
€100 EUR 3 napon belül
5,0 (5 értékelés)
4,0
4,0
Felhasználó avatár
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 7 napon belül
5,0 (7 értékelés)
3,7
3,7
Felhasználó avatár
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 1 napon belül
5,0 (3 értékelés)
3,3
3,3
Felhasználó avatár
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 2 napon belül
4,9 (26 értékelés)
3,1
3,1
Felhasználó avatár
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 2 napon belül
5,0 (2 értékelés)
2,9
2,9
Felhasználó avatár
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 1 napon belül
5,0 (2 értékelés)
2,1
2,1
Felhasználó avatár
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 2 napon belül
5,0 (1 értékelés)
1,1
1,1
Felhasználó avatár
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 3 napon belül
5,0 (1 értékelés)
0,6
0,6
Felhasználó avatár
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 7 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
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 1 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
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 3 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
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 7 napon belül
5,0 (1 értékelés)
0,0
0,0
Felhasználó avatár
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 7 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
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 1 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
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 3 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
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 7 napon belül
0,0 (0 értékelés)
0,0
0,0

Az ügyfélről

BELGIUM zászlója
Antwerp, Belgium
5,0
2
Fizetési mód hitelesítve
Tagság kezdete: okt. 10, 2020

Ügyfél-hitelesítés

Köszönjük! E-mailben elküldtük a linket, melyen átveheti ajándék egyenlegét.
E-mailje elküldése során valami hiba történt. Kérjük, próbálja újra.
Regisztrált Felhasználók Összes Közzétett Munka
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Előnézet betöltése
Hozzáférést adott a helymeghatározáshoz.
Belépési munkamenete lejárt, és kijelentkeztettük. Kérjük, lépjen be újra.