Date +1 considering list of holidays provided

[ismailzkhan]

Dear Techies,

Please help me in getting date + 1 considering list of holidays. If date+1 is holiday then it should reflect next working day. Attached excel for reference.

Please provide a formula, no VBA's pls as VBA's will not work due to limitation in my excel.

 

[Ratan Bhushan]

Hi Buddy

Please check the file and formula if this is what u r looking for.

 

[Somendra Misra]

Hi,

See this file.

Regards,

 

[ismailzkhan]

Dear Bhushan,

Thanks for your reply. I'm very sorry as I asked question wrongly in excel sheet. I need A2 +1 in B2, if A2+1 matches with dates in holidays list then next working day has to come. for example if A2=17-07-2015, B2 has to come 20-07-2015 (as 18 and 19 are in the list).

 

[Somendra Misra]

Dear Bhushan,

Thanks for your reply. I'm very sorry as I asked question wrongly in excel sheet. I need A2 +1 in B2, if A2+1 matches with dates in holidays list then next working day has to come. for example if A2=17-07-2015, B2 has to come 20-07-2015 (as 18 and 19 are in the list).

See this file, yellow cells and comment on the result.

Regards,

 

[ismailzkhan]

Dear Bhushan & Somendra,

Thanks for your help.. You are awesome