Prev: Validation list with formula?
Next: If & Vlookup statement
From: Sadad on 13 Apr 2010 12:13
PERFECT... IT WORKS :)

Thanks you...

"Biff" wrote:

> Hi!
>
> Try this:
>
> A1 = start date
> A2 = end date
>
> =NETWORKDAYS(A1+1,A2+1)
>
> If you need to exclude holidays:
>
> H1:H10 = list of holiday dates
>
> Entered as an array using the key combination of CTRL,SHIFT,ENTER.
>
> =NETWORKDAYS(A1+1,A2+1,H1:H10+1)
>
> Biff
>
> "Shay.C." <Shay.C.(a)discussions.microsoft.com> wrote in message
> news:8A9FBEA5-9E73-485A-9CB8-10D7D567C293(a)microsoft.com...
> > The NETWORKDAYS function regards Saturday and Sunday as weekends. I need
> > to
> > set Excel to regard Friday and Saturday as the weekend.
>
>
>
 | 
Pages: 1
Prev: Validation list with formula?
Next: If & Vlookup statement