LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default NETWORKDAYS ADD-IN PROBLEMS

Hello! I'm running across a problem with calculations -- i'm hoping i can
get a little help here. Some staff are not able to view my NETWORKDAYS
calculations due to excel 2002. It would be useless to have all 50+ staff
perform add-ins. Any thoughts? Also, I used another formula which came up
with more days? Maybe due to 30 or 31 calendar days?

Here's an example of my formulas:
start (b1) = 09/01/09
end (c1) = 09/30/09
=NETWORKDAYS(B1,C1,B45:B56)
This comes out to 21 days

=SUMPRODUCT(--(WEEKDAY(ROW(INDEX(A:A,B1):INDEX(A:A,C1)),2)<6))--(ISNA(MATCH(ROW(INDIRECT(B1&":"&C1)),B45:B56,0)))
This comes out to 22 days

Help is greatly appreciated!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
NETWORKDAYS The Rook[_2_] Excel Discussion (Misc queries) 3 September 5th 08 05:08 PM
NETWORKDAYS #NAME? Angiewelly Excel Discussion (Misc queries) 4 April 7th 08 04:20 PM
networkdays rsenn Excel Worksheet Functions 0 November 24th 05 12:42 AM
NETWORKDAYS = 0 ann Excel Discussion (Misc queries) 4 October 3rd 05 10:07 PM
Networkdays DKerr Excel Worksheet Functions 1 September 28th 05 03:30 PM


All times are GMT +1. The time now is 10:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"