Separate the weekends

[yoganantha321]

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

[tresesco]

May be like:

If(Match(Weekday([End Day]), 'Sat', 'Sun'), 'Weekend', Type) as Type

[yoganantha321]

Hi Tresesco,
As shown in the first image in between the weekends appear it should be automatically generate start date and end date as shown image 2

[tresesco]

So first image is your input and second one is expected output, right? If so, could you explain the logic a bit more, like how exactly you get second row of End Date (7/12/2018)?

[uacg0009]

I think because the 8/12/2018 is Sat, so the vacation is till to 7/12/2018.

[yoganantha321]

Yes Tresesco!!!

As said by Uacg0009

[PradeepReddy · Accepted solution]

See the attachment..

the solution is little bit lengthy..

[yoganantha321]

Thanks Pradeepreddy

[uacg0009]

Actually last night, I also created a solution, but didn't upload it...

But it's fine, you can check my script.

Thanks

Aiolos