| View previous topic :: View next topic |
| Author |
Message |
livemusic
General User
Joined: 17 Feb 2008
Posts: 21
Location: Louisiana, USA
|
 Posted: Wed May 21, 2008 11:53 pm Post subject: How to Count days in date range, excluding weekends |
 |
|
| Is there any way to do this? Say I have two columns of dates, Column A and Column B, the begin date of a contract and the end date. I want to create a column that would calculate the number of banking days in that range. Banking days generally being Mon - Fri. If there is way to also not count holidays, that's even better. Can anyone tell me the exact formula I need? |
|
| Back to top |
|
 |
Mark B
Super User
Joined: 16 Feb 2007
Posts: 852
Location: Lincolnshire, UK
|
| Posted: Thu May 22, 2008 12:31 am Post subject: |
|
|
Hi
Use NETWORKDAYS:
| Code: |
A1: 1/5/2008
B1: 31/5/2008
C1: =NETWORKDAYS(A1;B1)
|
Result in C1: 22
Mark
_________________
Mark B's Articles |
|
| Back to top |
|
|
keme
Moderator
Joined: 30 Aug 2004
Posts: 2732
Location: Egersund, Norway
|
| Posted: Thu May 22, 2008 12:35 am Post subject: |
|
|
Use the NETWORKDAYS() function.
You will have to make your own list of holidays as dates in a cell range, and refer to the range as the (optional) third parameter to the function. |
|
| Back to top |
|
|
|
