|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 23rd, 2010, 04:13 PM
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
March 23rd, 2010, 04:30 PM
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
March 23rd, 2010, 05:02 PM
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
March 23rd, 2010, 05:27 PM
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
March 23rd, 2010, 05:28 PM
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
March 23rd, 2010, 05:50 PM
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 .
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
