Forum home » Delegate support and help forum » Microsoft Excel Training and help » Day count function
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Day count function
Resolved · Medium Priority · Version 2003
Reply Wed 6 Oct 2010, 12:55Delegate Natalie said...
Natalie has attended:
Excel Advanced course
Day count function
I don't know if this is possible, but i want to be able to enter two dates and to come out with the number of weekdays between those two dates. is this possible?
Natalie
For upcoming training course dates see: Pricing & availability
RE: Day count function
Hi Natalie,
Thank you for your question and welcome to the forum.
You can achieve this byusing the NetworkDays function.
The first thing you need to do is add a AddIn. Go to Tools - AddIns. Tick the checkbox for Analysis Toolpack and then click OK.
In a blank cell go to Insert Function and type NetworkDays in the Search box and then select it from the recommended functions in the box below and click OK.
In the Start Date enter the cell reference for later date and then in the End Date box the earliest date giving you a positive result.
I hope this answers your question.
Regards
Simon
.
Thu 14 Oct 2010: Automatically marked as resolved.
|