Date Difference counting only working days

  • Thread starter Thread starter Peter
  • Start date Start date
P

Peter

Hi,

I know this might be simple but I need to calculate the
difference between two dates, but I need to count the
number of working days i.e. not saturday and sunday
betweeen the two dates.

Cheers

Peter
 
Hi
use NETWORKDAYS. e.g.
=NETWORKDAYS(A1,A2)

Note: You'll have to install the Analysis Toolpak addin to use this function
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating dates to include Saturdays but not Sundays 1
Remove non-business days between dates 3
Counting Days of Week 2
Working Days excluding Sundays 6
How can I count the working day 11
Date + X days excluding holidays 1
WeekDay count between dates 13
Excel Date Count 2

Back
Top