Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date Difference
Hello,
I have a forumla from the help that allows me to calculate the difference between two dates without weekends which is =NETWORKDAYS(D22,E22) and works great. However, I have two questions: 1. How do I get it to start from the next day instead of include the first date? i.e. 12/6/2007 - 12/12/2007 should be 4 workdays. I don't want to include 12/6/2007. 2. What if another user opens this spreadsheet and doesn't have the tool pak installed. Will the date formula still work? I ask because I had to install the tool pak on my computer. Thanks!!!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date difference = zero? | Excel Discussion (Misc queries) | |||
Calculating Difference Between Start Date & Time And End Date & Ti | Excel Discussion (Misc queries) | |||
difference two date | Excel Discussion (Misc queries) | |||
Date difference | Excel Worksheet Functions | |||
Difference of date | New Users to Excel |