Calculate a date after number of days without considering weekend holidays

[rameshppc]

Hi every one,

I am proud to be getting help from Mrexcel team on my every intoxicated situation on handling excel sheets.

Thanks team and now i need a help from you.

I am doing pan card service for people. i am entering the booking date in excel, i need a formula to show the date, after 10 from booking without considering weekend saturday & sunday.

Also its possible, to make the formula will consider the dates i written in particular cell as a holiday

 

[steve the fish]

Name means you haven't created the named range for your holidays. You don't have to use a named range. You could just use a reference to some cells. B1:B5 for example.