Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to Remove Weekend Days
I have a spreadsheet that I am trying to subtract the days between dates and
remove the weekend days from the calculation. example: G2 - F2 = ??? 5/23/2006 - 5/17/2006 = 4 TFTH, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to Remove Weekend Days
Try this:
For F2: StartDate G2: EndDate This formula requires the Analysis ToolPak add-in (ATP): H2: =NETWORKDAYS(F2,G2) This formula does not use the ATP: H2: =SUMPRODUCT(--(WEEKDAY(ROW(INDEX(A:A,F2):INDEX(A:A,G2)),2)<6)) Note: the NETWORKDAYS function accepts a third argument, a list of holidays which would not be counted as workdays. btw...unless you don't want to include the start date, there are 5 workdays between 5/17/2006 and 5/23/2006...In that case, just subtract 1 from the formula results. Does that help? *********** Regards, Ron XL2002, WinXP "Tom" wrote: I have a spreadsheet that I am trying to subtract the days between dates and remove the weekend days from the calculation. example: G2 - F2 = ??? 5/23/2006 - 5/17/2006 = 4 TFTH, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
need help with formula | Excel Discussion (Misc queries) | |||
Please help!! Vacation Accrual Formula | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Macro or Formula to remove Text from Cells | Excel Worksheet Functions |