working days excel

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Contact Us About Resources Sign in

Solutions Through Learning

Excellent

Request Callback We will call you back 0207 987 3777 Call for assistance Your Basket Basket is empty

Solutions Through Learning

Callback

Sign in

Basket

Menu

Call us on 0207 987 3777 or Search our website

Courses
- Application Training
  - Excel
    - All Excel
    - Introduction
    - Intermediate
    - Advanced
    - Advanced - Formulas & Functions
    - Advanced - For Power Users
    - VBA
    - VBA Introduction
    - VBA Intermediate
    - VBA Advanced
    - Charting
    - Dashboards for Business Intelligence
    - Advanced Excel Dashboards
    - Forecasting & Data Analysis
    - Power Query
    - PivotTables
    - PowerPivot
    - Financial Modelling
    - Excel for Finance Professionals
  - Microsoft Office 365
    - 365 Adoption Program
    - 365 Explained
    - 365 Ambassadors
    - 365 End Users
    - OneNote
    - Teams
  - ChatGPT
  - Power Automate
  - Power BI
  - Powerpoint
  - Access
  - Word
  - MS Project
  - Sharepoint
  - Outlook
  - Visio
  - View all 200+ Courses
- Productivity Training Programs
- Professional Development
  - All Professional Development
  - Taking Minutes
  - Time Management
  - Organisational Skills
  - Negotiating Skills
  - Presentation Skills
  - Effective Communication Skills
  - Assertiveness At Work
  - View all 50+ Courses
- Management Training
  - All Management Training
  - Introduction to Management
  - Managing Teams Remotely
  - Mentoring
  - Managing Change
  - Leadership Development
  - View all 50+ courses
- Sales & Customer Service
  - All Sales & Customer Service
  - Customer Service Excellence
  - Excellent Account Management
  - Fundamentals of Selling
  - Selling Skills Programme
  - View all 20+ courses
- Financial Training
  - All Financial Training
  - Finance for Non Financial Managers
  - Effective Budgeting and Beyond
  - View all Courses
- Project Management
  - All Project Management
  - Project Management course
  - Microsoft Project
  - PRINCE 2 Foundation
  - PRINCE 2 Practitioner
  - View all 18+ courses
- eLearning Solutions
Promotions
- Promotions
- Excel Courses London
Schedule
- Public Schedule
- How to Book
- Reschedule
- Last Minute Deals
- What to Expect
- Venues and Equipment Hire
- Industry Leading Pricing model
Formats
- All Formats
- Public Scheduled Courses
- On-Site Training
- Productivity Training Programs
- Closed Company Events
- Online Classroom (Virtual)
- Consultancy
- One to One Training
- Training Needs Analysis
- Floor Walking
- Roll Out
- E Learning
- Executive Coaching
Our Clients
- Client List
- Online Reviews
- Client Testimonials
- Client Feedback
- Featured Case Studies
Contact Us
About us
Resources
Your account
Sign in

Home » Resources » Forum

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Calculate working days in Excel?

Calculate working days in Excel?

Resolved · Low Priority · Version 2003

Tue 16 Sep 2008, 16:49 Delegate Laurence said...

Laurence has attended:
Excel Intermediate course

Calculate working days in Excel?

how do I calculate working days in excel?

Wed 17 Sep 2008, 13:31 Trainer Amanda said...

RE: working days in excel?

Hi Laurence

Thank you for your question.

If you look up NETWORKDAYS in Excel help, this will explain how this function works....basically it will give you the number of working days between two dates (excludes weekends and public holidays in it's count of days).

Amanda

Excel tip:

LARGE and SMALL functions and their uses

Two of Excel's most common functions are the MAX and MIN functions which will display the largest (MAX) or smallest (MIN) value in a series. What if you need the 2nd or 3rd largest or smallest values instead of the largest or smallest?

The =LARGE(array,n) returns the nth largest value of a series.

The =SMALL(array,n) function returns the nth smallest value of a series.

In both functions, 'n' represents the order of the number you want to display. For example, putting in 2 as n will give you the second highest number; putting in 3 as n will give you the third highest number.

View all Excel hints and tips

TrustPilot
TrustScore 4.8 / 5 2240 reviews

Request Callback

We will call you back

0207 987 3777

Call for assistance

Server loaded in 0.08 secs.