Calculate business days between 2 dates

  • Thread starter Thread starter Vic
  • Start date Start date
V

Vic

I need to calculate how many business days between 2 dates.
G2 is report submission date
H2 is report reviewed date
K2 is the result - how many days it took to review the report
My formula is =if(or(isblank(G2),isblank(H2)),"",networkdays(G2,H2))
This formula produces #NAME? in K2
How do I fix the formula (I am using Excel 2003)?
 
Type the word "networkdays" into Excel help, and see what it tells you.
 
Type the word "networkdays" into Excel help, and see what it tells you.
 
Nevermind. Thank you. I already got my answer. It requires Tools => Add-Ins
==> Analisys ToolPac installed and the formula should be:
=IF(OR(ISBLANK(G2),ISBLANK(H2)),"",(NETWORKDAYS(G2,H2)-1))
 
Nevermind. Thank you. I already got my answer. It requires Tools => Add-Ins
==> Analisys ToolPac installed and the formula should be:
=IF(OR(ISBLANK(G2),ISBLANK(H2)),"",(NETWORKDAYS(G2,H2)-1))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to find first row where condition is true? 12
Month & year question 4
Hours between dates 11
Excel A CountIF question... I think 2
Nested IF Formula 5
Matching the month and year portion of a date only 1
Time punch & hours calculations 1
Sum of multiple rows, based on date criteria, separate sheets... 0

Back
Top