Hi,
I have found a formula that get a date after excluding fridays & holidays at below thread:
Workday function to excluding fridays

the mentioned array formulas are:

for forward calculation:
Please Login or Register  to view this content.

for backward calculation:
Please Login or Register  to view this content.

My problem is after applying these formulas my workbook became too slow. I have 37 columns and in 8columns this formula is applied with 400 rows. Another problem is if I open two or more workbook together it become too much slow.

I am using office 2003 but If i need to move at office 2007 or 2010 I can switch to speed up calculation.

I have attached a demo file.

Thanks in advance for giving us always quick response.