Solved

count number of working days from a start date

Posted on 2014-01-30
7
216 Views
Last Modified: 2014-02-02
Hi Expert's excel 2007

I need to formula to work out the number of working day's that have passed from say from 01/10/2013..yo dates date.
0
Comment
Question by:route217
7 Comments
 
LVL 19

Assisted Solution

by:MINDSUPERB
MINDSUPERB earned 167 total points
Comment Utility
0
 
LVL 19

Expert Comment

by:MINDSUPERB
Comment Utility
0
 
LVL 26

Accepted Solution

by:
MacroShadow earned 167 total points
Comment Utility
=NETWORKDAYS(B1,B2,B3:B10)

B1 = First date
B2 = Last date
B3:B10 = Custom holidays (optional)

See this amazing tutorial.
0
Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

 
LVL 1

Assisted Solution

by:myomoto
myomoto earned 166 total points
Comment Utility
Good day.  

I think I understand your question.  Please tell me if I do not.

http://www.techrepublic.com/blog/microsoft-office/use-excel-to-calculate-the-number-of-working-days-you-have-to-complete-your-projects/#

This link will answer exactly your question.  Good luck mate!
0
 

Author Comment

by:route217
Comment Utility
Excellent thanks for the feedback. .
0
 
LVL 23

Expert Comment

by:NBVC
Comment Utility
.....................
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now