Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Networkdays function
Hi, I've been using the Networkdays function to work out the date 7 days
previous to today minus working days. I'm doing it in two stages, eg cell A1 = today(), cell A2 = 7, cell A3 = A1-A2, Cell A4 = Networkdays(A3, A1). However, it comes back with the answer 6 when I would expect to see 5. Does anyone know why that should happen? Also is there a quicker way of doing this? Help would be much appreciated. Thanks. Jean |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
NETWORKDAYS function | Excel Discussion (Misc queries) | |||
NETWORKDAYS function | Excel Discussion (Misc queries) | |||
Nesting Networkdays function inside and If function | Excel Worksheet Functions | |||
Networkdays function | Excel Worksheet Functions | |||
Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions |