Find Jobs
Hire Freelancers

Excel formula -- 3

€8-30 EUR

Terminado
Publicado hace más de 1 año

€8-30 EUR

Pagado a la entrega
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.
ID del proyecto: 35410650

Información sobre el proyecto

59 propuestas
Proyecto remoto
Activo hace 1 año

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
€0 EUR en 1 día
5,0 (72 comentarios)
5,4
5,4
59 freelancers están ofertando un promedio de €20 EUR por este trabajo
Avatar del usuario
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 en 1 día
5,0 (502 comentarios)
8,0
8,0
Avatar del usuario
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 en 5 días
4,8 (89 comentarios)
6,4
6,4
Avatar del usuario
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 en 1 día
4,7 (158 comentarios)
5,8
5,8
Avatar del usuario
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 en 1 día
4,9 (17 comentarios)
4,0
4,0
Avatar del usuario
hello sir, i generally understood the project, please accept my bid so we can discuss in more details. Best Regards
€100 EUR en 3 días
5,0 (5 comentarios)
4,0
4,0
Avatar del usuario
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 en 7 días
5,0 (7 comentarios)
3,7
3,7
Avatar del usuario
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 en 1 día
5,0 (3 comentarios)
3,3
3,3
Avatar del usuario
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 en 2 días
4,9 (26 comentarios)
3,1
3,1
Avatar del usuario
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 en 2 días
5,0 (2 comentarios)
2,9
2,9
Avatar del usuario
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 en 1 día
5,0 (2 comentarios)
2,1
2,1
Avatar del usuario
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 en 2 días
5,0 (1 comentario)
1,1
1,1
Avatar del usuario
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 en 3 días
5,0 (1 comentario)
0,6
0,6
Avatar del usuario
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 en 7 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 7 días
5,0 (1 comentario)
0,0
0,0
Avatar del usuario
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 en 7 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 7 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de BELGIUM
Antwerp, Belgium
5,0
2
Forma de pago verificada
Miembro desde oct 10, 2020

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.