LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 5th 18, 04:57 PM
Junior Member
First recorded activity by ExcelBanter: Mar 2012
Location: Singapore
Posts: 20
Send a message via Skype™ to GijsKijlstra
Default Networkdays based on condition needs help

The formula Iíve been using successfully to determine the number of weekend days and public holidays, is:
=M13-NETWORKDAYS(K13,L13,'2018 Public holidays'!$C$1:$C$11)
(M13 is the total number of days between K13, the start date and L13 the end date, '2018 Public holidays'!$C$1:$C$11 is the list of public holidays)

This works perfect for one country, with that country's specific public holidays

I now need to apply the same principle but now for different countries, based on the public holidays across different countries.
For this Iíve put the name of the country (e.g. USA or UK) in column H and in tab '2018 Public holidays' Iíve expanded the list of public holidays for both countries and added in column '2018 Public holidays'A:A, USA or UK for each public holiday date for each country.

How do I add the criteria of column H with the condition of column '2018 Public holidays'A:A?

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
New Sheet based on condition manfareed Excel Programming 11 August 13th 10 01:49 PM
how to delete a row based on a condition ya Excel Programming 2 December 17th 08 03:59 PM
Sum across sheets based on a condition GoBow777 Excel Worksheet Functions 3 March 8th 08 08:21 PM
Sum If based on a 3rd condition ? Steve Excel Worksheet Functions 5 August 18th 07 08:48 AM
Sum based on specific condition Wendy Excel Worksheet Functions 43 June 7th 07 09:25 PM

All times are GMT +1. The time now is 03:35 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright ©2004-2019 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017