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
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.
Thanks jdunkerley
