Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to determine the number of workday between two periods?
Referring to the post in General Question.
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.worksheet.functions
|
|||
|
|||
How to determine the number of workday between two periods?
On Feb 11, 10:50 pm, 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. Does anyone have any suggestion? Depends on what you call a "workday". Use Excel Help to learn about NETWORKDAYS(). If its definition of "workday" meets your needs, the solution might be simple: =networkdays(b1,a1) You might want to add the "holidays" argument. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
From Template Save As Help | New Users to Excel | |||
Changing a Number in a Column Using Arrays | Excel Worksheet Functions | |||
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 |