Date + X days excluding holidays
 

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

Date + X days excluding holidays
 

=NETWORKDAYS(TODAY(),DATE(Input!C1,Input!C2+1,0),H oliday)

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