Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Integrating Networkdays() Into Formula
Hello,
I'm trying to integrate the Networkdays() function into my code so that weekends are taken into account within the calculations. So far I have had zero luck in determining how to do this. Below is the code. =IF(A2<"",IF(H2=9,IF(G2<=$AO$2-Defs!D$3-1,1,0),IF(H2=5,IF(G2<=$AO$2-Defs!D$4-1,1,0),IF(H2=8,IF(G2<=$AO$2-Defs!D$8-1,1,0)))),"") To Explain the Cells that are used.... A2 - Axxx Contains text - the qty increases or decreases weekly H2 - Hxxx are simple numeric values to determine the category/type of line item so as to know the appropriate span of days allowed G2 - Gxxx Contains Dates that varies and may not be the same date from one to another AO2 - Holds the current date to be used for determining the end of the span for all dates in Column G Defs!D3 - Defs!Dxxx contains the length of date spans allowed for each category/type If a line item has exceeded it's allotted span then a number one in used to indicate so. If it is not past it's allotted span then a zero shows that there is still time left to be used. this worked great for months UNTIL I found out that I needed to Exclude Saturday & Sunday from the count of days to be used. Can anyone help me integrate the networkdays function so that it works as needed? Thanks in Advance! Rob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Integrating pictures in an excel document | Excel Discussion (Misc queries) | |||
Integrating a work sheet into another | Excel Discussion (Misc queries) | |||
Transforming a bitmap to text for integrating in Excell | Excel Discussion (Misc queries) | |||
URGENT !!! Integrating Axes | Charts and Charting in Excel | |||
Integrating Excel with Access | Excel Discussion (Misc queries) |