days caculation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello



Is there a way you can calculate working days between two days rather that
all days?



Thanks
 
look at the NETWORKDAYS() function, which requires you have the Analysis
Toolpak installed (tools-Addins.. and make sure the Analysis Toolpak is
checked)
 
This formula will give you the number of weekdays Monday through Friday
which fall in the date interval A1 to B1 inclusive:

=SUMPRODUCT(INT((B1-A1+WEEKDAY(A1-{2,3,4,5,6}))/7))

The bracketed array constant gives the Weekday numbers associated with days
Monday through Friday. Change the bracketed array constant to get a count
for other sets of days. For example, use {1,7} for weekend days (Saturdays
and Sundays), or {2,4,6} for Mondays, Wednesdays, and Fridays.

This does not account for holidays. If you need to do this, prepare a list
of holidays and reply back for more help. (Although I don't use NETWORKDAYS,
I'm sure you'd have to do this in that case too).
 
You must log in or register to reply here.

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

Project a date and calculate a % in one formula 4
If formula help 1
Adding up total hours worked on employee schedule using various criteria 0
Excel Formula for years and months 2
Outlook: Meeting recurrence every 6 WEEK days AND exclude weekends 0
Date/time difference 3
Calulating the number of days an employee works 6
Number of Weekend Days between 2 Dates Q 1

Back
Top