I have a spreadsheet that calculates the total number of days our vendors work. Column A is Start Date, Column B is Release Date, Column C is the NETWORKDAYS formula. Problem is our vendors work 10 hour days (i.e. 4 days a week). How can I use NETWORKDAYS to calculate for these people?
Also, I noticed if Column A is 1/1/2005 and Column B is 1/3/2005, NETWORKDAYS shows only 1 day worked "=NETWORKDAYS(A1,B1)". Why? It should be 3 days.
Thanks,
Jim
Also, I noticed if Column A is 1/1/2005 and Column B is 1/3/2005, NETWORKDAYS shows only 1 day worked "=NETWORKDAYS(A1,B1)". Why? It should be 3 days.
Thanks,
Jim