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

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

Kemahiran: Pemasukan Data, Pemprosesan Data, Kejuruteraan, Excel, Matematik

Lihat lagi: create custom table visio shape, create custom table headers myspace, sugarcrm create custom table, 4-4-5 calendar 2019 excel, 4-4-5 calendar 2018 excel, list.dates power query, excel formula for 4 4 5 fiscal calendar, 4–4–5 calendar algorithm, custom fiscal calendar in power query, power query 445 calendar, create 4-4-5 calendar in excel, create custom logo power ranger, create custom webpart query database, visio create custom table, access create custom error message duplicate index values table, access create custom query sql, create slides excel use power point, linq sql create custom query provider, create custom gridview control use project, power bi create new table from existing table

Tentang Majikan:
( 0 ulasan ) Warwick, United States

ID Projek: #19347421

14 pekerja bebas membida secara purata $149 untuk pekerjaan ini


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. Lagi

$220 USD dalam 3 hari
(324 Ulasan)

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, Tab Lagi

$100 USD dalam sehari
(50 Ulasan)

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 dalam 3 hari
(39 Ulasan)

Dear,sir. How are you? I read your project with great interest. We will make every effort to understand your intentions and satisfy you. I will not let you down with a blank and misshapen. I will wait Lagi

$100 USD dalam sehari
(2 Ulasan)

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 cli Lagi

$100 USD dalam 3 hari
(7 Ulasan)

Hi Dear. Don't worry for your project, i can do your project completely. Because of i'm dedicated and created developer for project and love to develop for you. if you don't satisfy my result, i will return your mon Lagi

$155 USD dalam 3 hari
(1 Ulasan)

Hi, I just checked your requirements and I know that you receive hundreds of proposal so without wasting any time let jump on a chat and get started. You can check my skills and work I did in my profile. Current w Lagi

$122 USD dalam 3 hari
(1 Ulasan)

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 dalam 3 hari
(0 Ulasan)

I can help , but I would like to now more details about this project. please share more details related to this project.

$155 USD dalam 3 hari
(0 Ulasan)

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 dalam 3 hari
(0 Ulasan)

We are data specialists with a proven background in data discovery, definition, integration and management. We are very proficient with all Microsoft office applications. We have a lot of previous experience with data Lagi

$155 USD dalam 6 hari
(0 Ulasan)

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 o Lagi

$155 USD dalam 3 hari
(0 Ulasan)

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 Lagi

$155 USD dalam 3 hari
(0 Ulasan)

Hello, Pretty interesting gig Since i am on it and i have the initial calendar in place let Source = Years, #"Converted to Table" = [login to view URL](Source, [login to view URL](), null, null, ExtraVa Lagi

$150 USD dalam 3 hari
(0 Ulasan)