ExcelBanter - How to determine the number of workday between two periods?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How to determine the number of workday between two periods? (https://www.excelbanter.com/excel-discussion-misc-queries/130267-how-determine-number-workday-between-two-periods.html)

Eric

How to determine the number of workday between two periods?

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

JE McGimpsey

How to determine the number of workday between two periods?

How about:

C1: =NETWORKDAYS(A1,B1)

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

In article ,
Eric wrote:

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.

All times are GMT +1. The time now is 01:14 PM.