Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
Solved

# count number of working days from a start date

Posted on 2014-01-30
Medium Priority
263 Views
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
Question by:route217
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points

LVL 19

Assisted Solution

MINDSUPERB earned 668 total points
ID: 39820474
0

LVL 19

Expert Comment

ID: 39820481
0

LVL 27

Accepted Solution

ID: 39820501
=NETWORKDAYS(B1,B2,B3:B10)

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

See this amazing tutorial.
0

LVL 1

Assisted Solution

myomoto earned 664 total points
ID: 39820506
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/#

0

Author Comment

ID: 39820517
Excellent thanks for the feedback. .
0

LVL 23

Expert Comment

ID: 39820674
.....................
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
###### Suggested Courses
Course of the Month4 days, 10 hours left to enroll