Exclude Weekends and Public holidays using one datefield

[#1]

Good day,

The question I asked earlier on was not so clear. Now I am simplifying it, I have a date field called LeaveDate and it contains Working days from Monday to Friday, Weekends and Holiday. So in my country if a holiday falls on a Sunday, then following day(i.e Monday) will be counted as a holiday. So in my attached spreadsheet, I have highlited the holidays and weekends in Yellow. So what I would like to exclude weekends and public holidays.

         

hope my question is clear.

Thanks

[sunny_talwar]

Exclude them how? Exclude them from loading? Also, do you have this second column which specify the word 'Holiday' or is that something you have to derive from another place?

[#3]

Hi Sunny,

May be have an indicator created to identify it's a holiday/weekend then I will use the indicator in my expression to exclude them in my calculation.

[sunny_talwar]

Weekend indicator is easy, how do we know if a certain date is a holiday? I mean 12/16/2016 is a holiday in your country, where do you get that information from?

[#5]

I actually have Public holiday spreadsheet which has holidays.

PFA

[raajaswin]

you can generate a consolidate holiday list then by using where not exist you can remove the holidays

[sunny_talwar]

I don't see the attachment, can you may be reattach?

[#8]

[sunny_talwar]

Since 25th Dec was a Sunday, you get extra holiday on 27th? because 26th was a Holiday also?

[raajaswin]

here holiday has been generated form 1/1/2015 to 1/1/2017  and your public holiday is added to that