Datedif exclude weekends

P

Paul

Hello newsgroup gurus and users.
Your kind assistance please.


This question has probably been asked a millions times but
I cant find it.

Does any one have a solution to this.

I want the date difference between two dates but exclude
weekends.

Many thanks
Paul
 
C

Chip Pearson

Paul,

The NETWORKDAYS function will return the number of days, excluding weekend
and optionally holidays, between two dates. See help for NETWORKDAYS for
more information. This function is part of the Analysis Tool Pack add-in so
you must have that add-in loaded; otherwise, you'll get a #NAME error.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com [email protected]
 
Top