Prev: Lookup on a combo box
Next: macro shortcut help
From: T. Valko on 23 Mar 2010 13:50
You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"LSG" <LSG(a)discussions.microsoft.com> wrote in message
news:E4E454AA-CABA-4D4B-8508-040512515752(a)microsoft.com...
> 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
>>
>>
>> .
>>


First  |  Prev  | 
Pages: 1 2
Prev: Lookup on a combo box
Next: macro shortcut help