Production time

kwagner

New Member
Joined
Oct 24, 2006
Messages
5
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
 

Some videos you may like

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

plettieri

Well-known Member
Joined
Sep 4, 2002
Messages
1,556
Platform
  1. MacOS
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
FGHI
11
12startenddays
1310/24/200610/30/20065
14
Sheet1



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

plettieri
 

Watch MrExcel Video

Forum statistics

Threads
1,114,671
Messages
5,549,346
Members
410,910
Latest member
DessertDiva
Top