| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Counting days between dates
Just wanted to add my 2 cents: this formula worked for me also, figuring
early and late shipments, where the NETWORKDAYS function kept adding an extra day. Thank you much. "Alex Delamain" wrote: Try this one then =IF(B8=A8,NETWORKDAYS(A8,B8)-1,NETWORKDAYS(A8,B8)+1) -- Alex Delamain ------------------------------------------------------------------------ Alex Delamain's Profile: http://www.excelforum.com/member.php...o&userid=11273 View this thread: http://www.excelforum.com/showthread...hreadid=265428 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula to calculate # of days between dates, excluding holidays | Excel Discussion (Misc queries) | |||
| how do I calculate the days between dates? | Excel Discussion (Misc queries) | |||
| Counting days worked | Excel Worksheet Functions | |||
| Subracting Dates to come up with the # of days between them | Excel Worksheet Functions | |||
| counting entries between two dates? | Excel Worksheet Functions | |||
Threaded Mode
