Production time

[kwagner]

I would like to be able to calculate production time using actual dates. I have tried NETWORKDAYS & WORKDAY but both require that you input the date in the formula. I would like to be able to calculate actual production dates excluding weekends and holidays from cells in my spreadsheet.
Example: start date 10/24/06, end date 10/30/06 = 5 production days

Thanks

 

[plettieri]

Hi:

Using a location for the start and end dates

SCRIPT language=JavaScript src="http://www.interq.or.jp/sun/puremis/colo/popup.js"></SCRIPT>

Book1
	F	G	H	I
11
12	start	end	days
13	10/24/2006	10/30/2006	5
14
Sheet1

You need to identify holidays, if any, as the element of the formula.

plettieri