| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can excel calc the difference between 2 dates removing weekends?
Does anyone know how to get excel to create the numbers of days difference
between 2 dates and removing the weekends at the same time using a formula? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can excel calc the difference between 2 dates removing weekends?
Adam wrote:
Does anyone know how to get excel to create the numbers of days difference between 2 dates and removing the weekends at the same time using a formula? Hi Adam, you can use simply the function NETWORKDAYS: =NETWORKDAYS(start_date,end_date) -- Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Difference between 2 dates, incl weekends, with variable work days | Excel Worksheet Functions | |||
| How to calc # of days between two dates in YYYYMMDD in EXCEL. | Excel Discussion (Misc queries) | |||
| I need the difference between two dates expressed as 4 years 3 mo. | Excel Discussion (Misc queries) | |||
| Subtracting dates to get hours... but I want to skip weekends | Excel Discussion (Misc queries) | |||
| Excel not recognizing Dates properly. | Excel Discussion (Misc queries) | |||
Linear Mode
