Hi,
Request your help with this.
I need a formula to exclude all holidays (listed in a separate sheet), but no weekend to be excluded.
Tried Networkdays, and Networkdays.intl, both doesnt serve the purpose.
Want TAT including all weekends but excluding holidays (listed in a separate sheet)
Please mark the thread as [SOLVED] when answered.
If you're happy with an answer given, please click the * under the person's name to boost their reputation.
Try this...
A1 = start date
B1 = end date
Holidays = list of holiday dates
=NETWORKDAYS.INTL(A1,B1,"0000000",Holidays)
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
You're welcome. Thanks for the feedback!
@ Tony Valko,
I thought NETWORKDAYS.INTL didn't become available until Excel 2010. Is my info wrong?
Dave
Correct.Originally Posted by FlameRetired
The OP's profile says they're using Excel 2007 but they also said this:
So I assumed they were using at least Excel 2010.Tried Networkdays, and Networkdays.intl, both doesnt serve the purpose.
Ahhh! I missed that detail.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks