Excel: Holidays and networkdays
Article updated on October 28, 2007
How to include additional holidays to excels networkdays formula.
NETWORKDAY(start_date; end_date; [holidays])
Returns the number of whole workdays between two dates
Recommended posts
Steven asks: I got 6 events with different dates... Event - DATE START - DATE END 1 2 3 4 […]
Question: How do I highlight duplicates in a range of dates, not considering those outside the date range? See picture […]
I have created a new version of Visualize date ranges in a calendar. This excel file let´s you enter names […]
The NETWORKDAYS function returns the number of working days between two dates, excluding weekends. It also allows you to ignore […]
Bryan asks: i am trying to do a conditional formatting for a calendar row. (essentially, a gant chart) i have […]
How many of a specific weekday falls between a start date and an end date except holidays
Steve asks: Right now I'm using the following formula to tell me how many of a specific defined day, ie […]
This post explains how to lookup a value and return multiple values. No array formula required.
Lookup and return multiple values concatenated into one cell
This article demonstrates how to find a value in a column and concatenate corresponding values on the same row. The […]
Question: How do I create a chart that dynamically adds the values, as i type them on the worksheet? Answer: […]
Leave a Reply
How to add a formula to your comment:
<code>your formula</code>
Remember to convert less than and larger than signs to html character entities before you post your comment.
How to add VBA code to your comment:
[vb 1="vbnet" language=","]
VBA code
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org
Add picture link to comment.
Share this article