Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counting function with weekdays only
I need a formula to show this result : The 3rd business (weekdays only) day
after an application is taken. Can anyone help? -- -Liz |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counting function with weekdays only
Try this...
A1 = some date =WORKDAY(A1,3) Format as Date Note that the WORKDAY function requires the Analysis ToolPak add-in be installed if you're using a version of Excel prior to Excel 2007. If you enter the formula and get a #NAME? error look in Excel help for the WORKDAY function. It'll tell you how to fix the problem. -- Biff Microsoft Excel MVP "LSG" wrote in message ... I need a formula to show this result : The 3rd business (weekdays only) day after an application is taken. Can anyone help? -- -Liz |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counting function with weekdays only
Liz,
With your order date in a1 try this formatted as a date =WORKDAY(A1,3) Note the formula can take a third argument =WORKDAY(A1,3,Holidays) Where Holidays is a named range of holiday dates you want to ignore Note the -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "LSG" wrote: I need a formula to show this result : The 3rd business (weekdays only) day after an application is taken. Can anyone help? -- -Liz |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counting function with weekdays only
It works perfect! Thanks!
-- -Liz "T. Valko" wrote: Try this... A1 = some date =WORKDAY(A1,3) Format as Date Note that the WORKDAY function requires the Analysis ToolPak add-in be installed if you're using a version of Excel prior to Excel 2007. If you enter the formula and get a #NAME? error look in Excel help for the WORKDAY function. It'll tell you how to fix the problem. -- Biff Microsoft Excel MVP "LSG" wrote in message ... I need a formula to show this result : The 3rd business (weekdays only) day after an application is taken. Can anyone help? -- -Liz . |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counting function with weekdays only
Didn't even think of the holidays. Thanks Mike!
-- -Liz "Mike H" wrote: Liz, With your order date in a1 try this formatted as a date =WORKDAY(A1,3) Note the formula can take a third argument =WORKDAY(A1,3,Holidays) Where Holidays is a named range of holiday dates you want to ignore Note the -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "LSG" wrote: I need a formula to show this result : The 3rd business (weekdays only) day after an application is taken. Can anyone help? -- -Liz |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counting function with weekdays only
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "LSG" wrote in message ... It works perfect! Thanks! -- -Liz "T. Valko" wrote: Try this... A1 = some date =WORKDAY(A1,3) Format as Date Note that the WORKDAY function requires the Analysis ToolPak add-in be installed if you're using a version of Excel prior to Excel 2007. If you enter the formula and get a #NAME? error look in Excel help for the WORKDAY function. It'll tell you how to fix the problem. -- Biff Microsoft Excel MVP "LSG" wrote in message ... I need a formula to show this result : The 3rd business (weekdays only) day after an application is taken. Can anyone help? -- -Liz . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Weekdays | Excel Discussion (Misc queries) | |||
counting function but not double counting duplicates | Excel Worksheet Functions | |||
Weekdays only! | Excel Discussion (Misc queries) | |||
Number of Weekdays | Excel Worksheet Functions | |||
Weekdays | Excel Discussion (Misc queries) |