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
|