Power Query: List with values and names split across working days

New Contributor

Hello all,

 

I am wondering if it will be possible to split values from a list to working days.

 

Document i have: List of over 100 individuals with the total working days in a month.

 

Document i want: List of those 100 individuals split over working days of a certain month and the total working days split over that period.

 

I am using latest version of excel and have Power Bi as well if needed.

 

Example: 

What i have

Person A15
Person B20
Person C18

 

Example:

What i want

 

Person A01/06/2022 (DD/MM/YYYY)1
Person A02/06/20221
Person A03/06/20221
Person A05/06/20221
Person Aetcetc until the total working days is filled.
Person B01/06/2022 1
 02/06/20221
 03/06/20221
 05/06/20221
etc etc until the total working days is filled.

 

 

1 Reply

Hi @GeDemu 

 

Start date not mentioned so I assumed 1st working day of current Month/Year (easy to change)

Function WORKDAY by ImkeF

_Screenshot.png

See attached file