Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
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?
Reply
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 04:59 PM
Sum across sheets based on a condition GoBow777 Excel Worksheet Functions 3 March 8th 08 09: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 05:59 PM.

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

About Us

"It's about Microsoft Excel"