#Name? Error when using NETWORKDAYS function ......

  • Thread starter Thread starter SeanAlexander
  • Start date Start date
S

SeanAlexander

Hi,

I'm creating a spreadsheet which is meant to calculate the number of
days a person has worked between succesive weeks, given a specific
start date and end date of work for that person. I define the weeks by
the start date of the week (ie the date of every Monday). I've been
sitting and staring at this darned formula since yesterday, the logic
seems fine but I guess its a problem with the syntax or something.
Here's the formula I've used -

=IF(End Date < Week Beginning Date,0,IF(Start Date < Week Beg Date,IF
(End Date < Next Week Beg Date,
NETWORKDAYS(Week Beg Date,End Date),NETWORKDAYS(Week Beg Date,Next Week
Beg Date)),IF (Start Date > Week Beg
Date,NETWORKDAYS(Start Date,Next Week Beg date),NETWORKDAYS(Start
Date,End Date))))

Would appreciate any help anyone can give me on this.

Thanks,

Sean.
 
Thanks a Ton !!! :)) It works !!! I didnt know that that had to be
installed .... Are there any other functions that require this tool
pack specifically ?
 
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

networkdays alternative 2
Multi NetWorkDays Calculation 3
Re: How can I count the number of SATURDAYS in a month? 0
Networkday & workday with array functions 1
Can't get NETWORKDAYS to calc elapsed banking days in a month 2
Calculate workdays for irregular work patterns 1
How to calculate the number of Workdays for irregular work pattern 1
how can i networkdays date ranges where dates overlap 1

Back
Top