How to determine the number of workday between two periods?

E

Eric

Does anyone know how to determine the number of workdays between two periods?
such as today in cell a1, and 26-Feb-2005 in cell b1, the number of workdays
in cell c1.
Does anyone have any suggestion?
Thank you in advance
Eric Choi
 
J

JE McGimpsey

How about:

C1: =NETWORKDAYS(A1,B1)

NETWORKDAYS is in the Analysis Toolpak Add-in (Tools/Add-ins...)
 

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 determine the number of workday between two periods? 1
How to determine the number of months between 2 periods? 2
How to count the number of months between 2 periods? 3
How to determine the number of month between 2 periods? 5
How to determine the number of months between 2 periods? 0
Calendar Logic: Recurring Dates 3
How to determine the highest occurrence? 4
How to determine the closed value? 7

Top