| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculating the difference between to dates
I have 2 columns of data, A = Start date B = End date.
I am wanting to calculate how long it as take to perform the process, obviously B-A will give me this result but we do not work weekend and I am wanting to calculate the days excluding weekends. Is there an easy way? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Calculating the difference between to dates
Use =NETWORKDAYS(A1,B1) to calculate the NET WORKing DAYS between th two dates in A1 and B1. Co -- colofnatur ----------------------------------------------------------------------- colofnature's Profile: http://www.excelforum.com/member.php...fo&userid=3435 View this thread: http://www.excelforum.com/showthread.php?threadid=56278 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Calculating the difference between to dates
See the function Net WorkDays. It is included with the add-in named Analysis
Tool Pack. Mike F "TheRook" wrote in message ... I have 2 columns of data, A = Start date B = End date. I am wanting to calculate how long it as take to perform the process, obviously B-A will give me this result but we do not work weekend and I am wanting to calculate the days excluding weekends. Is there an easy way? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating Difference Between Two Dates Using Only Year | Excel Discussion (Misc queries) | |||
| Calculating difference between dates | Excel Discussion (Misc queries) | |||
| Calculating difference between times on 2 dates | Excel Worksheet Functions | |||
| Calculating the difference between two dates if two criteria are m | Excel Worksheet Functions | |||
| Calculating the difference between 2 dates and times | Excel Discussion (Misc queries) | |||
Linear Mode
