Date + X days excluding holidays

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
 
B

Brad

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Working Days function copied down column 1
Date Calculation Formula- Calendar days minus Holidays 1
Count the remaining weekdays in a data range excluding holidays and start/end dates 5
vacation excluding holidays 1
Calculating dates to include Saturdays but not Sundays 1
Calculating calendar days excluding holidays 3
NETWORKDAYS function 1
time interval between dates incl weekends excl holidays 7

Top