Weekends as separate

[Yoga321]

Hi all,

I have a data set as list of dates with the type as shown in image1. But i need a new type as weekends as shown in image 2. 

Anybody help in this!!!!

I have attached a sample file along with this.

Regards,

Yoganantha Prakash G P

[jdunkerley79 · Accepted solution]

I suggest using a generate rows to create all the days and then summarising back together. You need to use a multi-row formula tool to create the groupings.

Sample attached.

[Yoga321]

Thanks jdunkerley