View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Brad Brad is offline
external usenet poster
 
Posts: 846
Default 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