counting function with weekdays only
in [Functions]
|
Prev: Lookup on a combo box
Next: macro shortcut help
From: LSG on 23 Mar 2010 12:13 I need a formula to show this result : The 3rd business (weekdays only) day after an application is taken. Can anyone help? -- -Liz
From: T. Valko on 23 Mar 2010 12:30 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" <LSG(a)discussions.microsoft.com> wrote in message news:6787E484-17E6-47EB-926F-BA15260FFA37(a)microsoft.com... >I need a formula to show this result : The 3rd business (weekdays only) >day > after an application is taken. > > Can anyone help? > > > -- > -Liz
From: Mike H on 23 Mar 2010 13:02 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
From: LSG on 23 Mar 2010 13:27 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" <LSG(a)discussions.microsoft.com> wrote in message > news:6787E484-17E6-47EB-926F-BA15260FFA37(a)microsoft.com... > >I need a formula to show this result : The 3rd business (weekdays only) > >day > > after an application is taken. > > > > Can anyone help? > > > > > > -- > > -Liz > > > . >
From: LSG on 23 Mar 2010 13:28
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 |