Prev: how do i see which data matches between two worksheets?
Next: How do I make cells not move in a worksheet
From: excelrookie on 25 Feb 2010 13:09
How would I write a formula that would do this. If I input a date in cell A1
and I have holidays in cells R1:R11. Can I write a formula that would give
me a date in cell B2 that is 7 business days excluding holiday from the date
in A1.

I am having a hard time getting the networkdays and holidays working if I am
not inputing 2 dates.

Thanks
From: T. Valko on 25 Feb 2010 13:19
>I am having a hard time getting the networkdays
>and holidays working

Use the WORKDAY function:

=WORKDAY(A1,7,R1:R11)

Format as Date

--
Biff
Microsoft Excel MVP


"excelrookie" <excelrookie(a)discussions.microsoft.com> wrote in message
news:6B1A82D4-15C6-4FBE-9E6A-B3C2CDF7B9E4(a)microsoft.com...
> How would I write a formula that would do this. If I input a date in cell
> A1
> and I have holidays in cells R1:R11. Can I write a formula that would
> give
> me a date in cell B2 that is 7 business days excluding holiday from the
> date
> in A1.
>
> I am having a hard time getting the networkdays and holidays working if I
> am
> not inputing 2 dates.
>
> Thanks


From: excelrookie on 25 Feb 2010 13:46
Thanks guys but I figured it out workday with holidays excluded :)

"excelrookie" wrote:

> How would I write a formula that would do this. If I input a date in cell A1
> and I have holidays in cells R1:R11. Can I write a formula that would give
> me a date in cell B2 that is 7 business days excluding holiday from the date
> in A1.
>
> I am having a hard time getting the networkdays and holidays working if I am
> not inputing 2 dates.
>
> Thanks
 | 
Pages: 1
Prev: how do i see which data matches between two worksheets?
Next: How do I make cells not move in a worksheet