| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula is not working
Hello! I am having a problem with my formula for ontime delivery. I have two columns with dates in them and want to have the difference between the two excluding weekends. My current formula is =networkdays(E2,F2)-1. When I try to change a date, it gives me #Name? Any help would be appreciated!! Thank you, Heather -- olivia824 ------------------------------------------------------------------------ olivia824's Profile: http://www.excelforum.com/member.php...o&userid=14380 View this thread: http://www.excelforum.com/showthread...hreadid=497659 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula is not working
Are you sure that you have the Analysis Toolpak addin checked (ToolsAddins)
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "olivia824" wrote in message ... Hello! I am having a problem with my formula for ontime delivery. I have two columns with dates in them and want to have the difference between the two excluding weekends. My current formula is =networkdays(E2,F2)-1. When I try to change a date, it gives me #Name? Any help would be appreciated!! Thank you, Heather -- olivia824 ------------------------------------------------------------------------ olivia824's Profile: http://www.excelforum.com/member.php...o&userid=14380 View this thread: http://www.excelforum.com/showthread...hreadid=497659 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula is not working
Thank you! I got it now. I didn't even know you could uncheck a addin. -- olivia824 ------------------------------------------------------------------------ olivia824's Profile: http://www.excelforum.com/member.php...o&userid=14380 View this thread: http://www.excelforum.com/showthread...hreadid=497659 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is it possible? | Excel Worksheet Functions | |||
| Formula to find the working days difference between to dates? | Excel Discussion (Misc queries) | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Looking for a working production formula so I can add to staff? | Excel Discussion (Misc queries) | |||
| Formula entered not working | Excel Discussion (Misc queries) | |||
Linear Mode
