No. days between dates excl. Sat & Sun ie work days only

[Guest]

Is it possible to have a formula which calculates the no. of days between 2 dates, but excludes Sat & Sun?

e.g. 04/02/02 & 16/02/02 = 10 working days

 

[Scott]

On 2002-02-19 11:30, Anonymous wrote:
Is it possible to have a formula which calculates the no. of days between 2 dates, but excludes Sat & Sun?

e.g. 04/02/02 & 16/02/02 = 10 working days

You can use =NETWORKDAYS(A1,A2) Assuming that A1 contains the start date, and A2 contains the end date.