Re: Datedif exclude weekends

Giganews Newsgroups
Subject: Re: Datedif exclude weekends
Posted by:  Chip Pearson (ch…@cpearson.com)
Date: Thu, 16 Oct 2003

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    ch…@cpearson.com

"Paul" <anonymo…@discussions.microsoft.com> wrote in message
news:0d7101c393d3$e5419990$a30128…@phx.gbl...
> 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

Replies

None

In response to

Datedif exclude weekends posted by Paul on Thu, 16 Oct 2003