Find Jobs
Hire Freelancers

Use Power Query to create a custom 4-4-5 Calendar Table with offsets based on today

$30-250 USD

Cerrado
Publicado hace casi 5 años

$30-250 USD

Pagado a la entrega
I am looking use Power Query to create a custom 4-4-5 Calendar table with offsets. I have attached an example of what I want as an excel file. Below are some of the "rules" that apply to the calendar and where I've struggled: (1) Weeks run from Sunday to Saturday (2) If Jan 1st falls between Sunday and Tuesday, the fiscal month [[login to view URL]] for January will end on the 4th Saturday. If Jan 1st falls between Thursday and Saturday, then January's [[login to view URL]] will end on the 5th Saturday. (3) There is a column that returns Today's fiscal month [[login to view URL]] as a number. For example, if today were April 29th, its fiscal month [[login to view URL]] would be 5 not 4. (4) Each year ends on December 31st (extra days from the 28day-28day-35day pattern are added into December (5) There are index numbers for each day/week/month of each year (6) The calendar runs from 2017 to 2020
ID del proyecto: 19347421

Información sobre el proyecto

11 propuestas
Proyecto remoto
Activo hace 5 años

¿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
11 freelancers están ofertando un promedio de $152 USD por este trabajo
Avatar del usuario
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
$220 USD en 3 días
4,9 (360 comentarios)
8,0
8,0
Avatar del usuario
Hello, I have experience in power query and I'm a certified advanced excel expert with a decade of experience if you hire me I'll deliver the work up to your satisfaction.
$250 USD en 3 días
5,0 (53 comentarios)
7,0
7,0
Avatar del usuario
I can definitely help you with that. I am a professional Data Analyst and Excel expert holding years of experience in utilizing advance level tools and functions of various data analytics softwares including Excel, Tableau and Power BI to create highly dynamic and automated dashboards and templates and perform various types of calculations, automation, analysis and computation. I will be happyt to discuss in detail how I am highly suitable for this project.
$100 USD en 1 día
4,7 (67 comentarios)
5,6
5,6
Avatar del usuario
Hi There, I am very much interested in doing this project. I am having a very rich experience in this field. Please give me a chance to work for you. You can check my previous project feedback/Review/Rating from clients. Please consider my bid also. Please. Thanks
$100 USD en 3 días
5,0 (9 comentarios)
2,3
2,3
Avatar del usuario
I want to do this. I can do this well. I will be able to finish this task within the due time. I can do exactly as you wanted.
$155 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I can help , but I would like to now more details about this project. please share more details related to this project.
$155 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I’m able to use my skills as a programmer to write a code to automate the process Which will results in more productivity and accuracy in addition to reuse ability for more what required
$111 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi Dear, Having elevated the performance and profitability of diverse organizations through expert alignment of innovative marketing and advertising strategies, I am writing to offer your company more than 6 years of experience in creative development/leadership of promotional campaigns and creative marketing management. As a reputable and honored contributor to many top organizations, I am confident in my abilities to generate superior results for your company as Digital Marketing Manager. Sincerely, Helen
$155 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Data Entry via google docs, Excel, Word, web based software, CMS > Google Map Lookup: Searching for businesses in different industries worldwide and finding their complete addresses, phones, and URL's. > Google Earth Lookup for exact coordinates (counting task, longitude, latifude) > Company Contact Names Lookup/Harvesting
$155 USD en 3 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
Warwick, United States
0,0
0
Forma de pago verificada
Miembro desde abr 25, 2019

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.