Most valuable professional
  • Hot Topics

Excel Finding if a bank holiday is between two dates (from a list)

Hello, I have two dates as shown in the example below: 14/04/2014 04:50 and 17/04/2014 23:30:00 How would I determine whether a bank holiday from a list like this, falls betweens those two dates? Bank Holiday List: 1/1/2014 18/01/2014 21/04/2014 5/5/2014 26/05/2014 25/08/2014 25/12/2014 26/12/2014 Many thanks for any help you can provide. James

This question generated 22 answers. To proceed to the answers, click here.

This thread is current as of December 23, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel