Question: how to create a formula in excel to calculate business days?
Answer: Click inside the cell where the formula will reside. Type =networkdays( Then type in the first date of the range encased in "". For example "4/6/2012". Then type a comma and the end date of the range encased in quotes. Close your parenthis and hit enter.