| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to determine the number of workday between two periods?
Does anyone know how to determine the number of workdays between two periods?
such as today in cell a1, and 26-Feb-2005 in cell b1, the number of workdays in cell c1. Does anyone have any suggestion? Thank you in advance Eric Choi |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to determine the number of workday between two periods?
How about:
C1: =NETWORKDAYS(A1,B1) NETWORKDAYS is in the Analysis Toolpak Add-in (Tools/Add-ins...) In article , Eric wrote: Does anyone know how to determine the number of workdays between two periods? such as today in cell a1, and 26-Feb-2005 in cell b1, the number of workdays in cell c1. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto Number in Invoice | New Users to Excel | |||
| From Template Save As Help | New Users to Excel | |||
| Pulling Data off Web - Need Function Help | Excel Worksheet Functions | |||
| Formula to determine whether number falls within range?? | Excel Worksheet Functions | |||
| Formula to determine number of Standard Deviations based on % of population | Excel Worksheet Functions | |||
Linear Mode
