Datedif exclude weekends

  • Thread starter Thread starter Paul
  • Start date Start date
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
 
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 (e-mail address removed)
 

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

Date + X days excluding holidays 1
Diff in business days 2
time interval between dates incl weekends excl holidays 7
Calculate number of WEEKENDS between two dates? 3
Calculate number of hours between dates and times excluding Weekends 1
Outlook: Meeting recurrence every 6 WEEK days AND exclude weekends 0
Subtracting Dates to get total time work time excluding weekends 2
Calculate date difference exclude Wkend 4

Back
Top