Excel - calculate weekdays

A

Aladin Akyurek

=NETWOKDAYS(Date1,Date2)

where Date1 <= Date2.

You need to activate the Analysis Toolpak add-in.
 
P

Peo Sjoblom

Try NETWORKDAYS

=NETWORKDAYS(start,end,holidays)

you need ATP (analysis toolpak) installed
if you get a name error click tools>add-ins and check
Analysis ToolPak, keep the excel/office CD handy and follow the instructions

Regards,

Peo Sjoblom
 

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

Count the remaining weekdays in a data range excluding holidays and start/end dates 5
Excel: counting times and dates during non-traditional hours 0
2016 Project, adding a workday to custom field 0
number or working days 6
Turning off automatic calculation 0
Search closest day in the past from today 2
WEEKDAY 7
How to calculate dates 6

Top