Date + X days excluding holidays

  • Thread starter Thread starter cousinexcel
  • Start date Start date
C

cousinexcel

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
 
=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"
 
Back
Top