Dates Filtering

[shaikhrulez]

Hello Everyone,

Happy New Year, hope you experts are doing great. Once again I'm stuck in a situation therefore your kind help is needed.

Please refer to attached file. There are 2 sheets, Working-I and Sheet3.

Working-I contains Date of Collection and Settlement Date, Sheet3 contains list of holidays from Dec-2015 to July-2016 including Saturday/Sunday and other gazetted holidays.

Now, I would like to highlight cases where the difference between Date of Collection and Settlement Date is beyond the list of holidays (Sheet3) or does not include the days mentioned in Sheet3.

I hope I've explained it well, still if there is any confusion please feel free to ask..

Waiting for response. Thanks.

 

[PCosta87]

Hi,

I would use a helper sheet like in the attachment.
As you can see, only 11-07-2016 to 13-07-2016 does not contain a holiday.

I hope I understood correctly and if so I hope this helps

 

[shaikhrulez]

Hi,

I would use a helper sheet like in the attachment.
As you can see, only 11-07-2016 to 13-07-2016 does not contain a holiday.

I hope I understood correctly and if so I hope this helps

Thanks @PCosta87 it worked perfectly

 

[PCosta87]

Thanks @PCosta87 it worked perfectly

Don't mention it