Population of dates between dates

[Dev-13]

Hi 

I have a week start and a week end date. I have days of the week but no date is assigned to them. I would like a date assigned to the actual day that falls inbewteen the week start and end date. In the example below Monday would have 24/10/2022 assigned

Data looks like this:

[Week start] [week end ] [day of week] [total]

23/10/2022   29/10/2022    Monday    10

23/10/2022   29/10/2022    Wednesday    5

23/10/2022   29/10/2022    Monday    10

23/10/2022   29/10/2022    Tuesday    6

Thanks 

[rsbin · Accepted solution]

@Dev-13 ,

Easiest way is create a Calculated Column:

Date = SWITCH(
           TRUE(),
           [Day of Week] = "Monday", DayofWeek[Week Start] + 1,
           [Day of Week] = "Tuesday", DayofWeek[Week Start] + 2,
           [Day of Week] = "Wednesday", DayofWeek[Week Start] + 3,
           [Day of Week] = "Thursday", DayofWeek[Week Start] + 4,
            [Day of Week] = "Friday", DayofWeek[Week Start] + 5,
             [Day of Week] = "Saturday", DayofWeek[Week Start] + 6 )

Trust this helps.

Regards,