Prev: Filtering
Next: Embedded File Not Opening Correctly
From: cousinexcel on 27 Jan 2010 08:51
Hi,

I need
Date + X days= ?
excluding the holidays I write in a range.

Workday function would exacltly solve my need if it did not exclude the
weekends.

If this is not possible, I may also try an indirect way if you can help me
count the number of saturdays between two dates.

Thanks and regards,

CousinExcel
From: Brad on 27 Jan 2010 10:00
=NETWORKDAYS(TODAY(),DATE(Input!C1,Input!C2+1,0),Holiday)

You would need to key in what dates would be considered "holidays". In the
above example the cells contain holidays has been range named as "Holiday"

--
Wag more, bark less


"cousinexcel" wrote:

> Hi,
>
> I need
> Date + X days= ?
> excluding the holidays I write in a range.
>
> Workday function would exacltly solve my need if it did not exclude the
> weekends.
>
> If this is not possible, I may also try an indirect way if you can help me
> count the number of saturdays between two dates.
>
> Thanks and regards,
>
> CousinExcel
 | 
Pages: 1
Prev: Filtering
Next: Embedded File Not Opening Correctly