| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating difference between dates
DUNNER7 wrote:
I have column c with the start date ex. 9/4/2009 and column d leave date ex. 11/02/09. How can I calculate number of school days (no SAT and SUN) that the student attended between these two dates in column e? Thanks Del Dobbs Use NETWORKDAYS ( you will need the analysis addin if using Excel 2003) Syntax = NETWORKDAYS( Start_date, End_date, Holidays) edvwvw -- Message posted via http://www.officekb.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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) | |||
| Irregularity in calculating difference between two dates | Excel Discussion (Misc queries) | |||
| Calculating the difference between cells | Excel Worksheet Functions | |||
Threaded Mode
