Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
my two dates:
h131=1/14/2008 i131=1/22/2008 formula used: =networkdays(h131, i131) answer given = 7 real answer should be 5 correct (subtract sat and sunday and get 5) thanks "Jeff Boyce" wrote: We aren't there. We can't see what you're looking at. More specific description is likely to lead to more specific suggestions... Regards Jeff Boyce Microsoft Office/Access MVP "whahappened..." wrote in message ... i installed the analysis pack and yet it is still calculating one extra weekend. I attempted with the date function (=date(year, month, day)) and with just a normal date; however, it is still giving me 7 instead of 5! What I am doing wrong!? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Networkdays function | Excel Worksheet Functions | |||
Nesting Networkdays function inside and If function | Excel Worksheet Functions | |||
NETWORKDAYS FUNCTION, Help please | Excel Worksheet Functions | |||
Networkdays function | Excel Worksheet Functions | |||
Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions |