Hi Sir Philippe,
thanks for the link, yet I cannot find the solution..

I need a match or a lookup of floating dates within the 2 given dates.

e.g.
date given 1 = 01/Dec/06
date given 2 = 20/Feb/06

holiday list
08/Dec/06 <
31/Dec/06 <
01/Jan/06 <
20/Feb/06 <
01/May/06

then the desired count of holiday = 4

i hope i have explained it clearly...

i am so confused because my boss request me with a single formula, even a
long formula will do

happy holidays
driller


"Philippe L. Balmanno" wrote:

"dribler2" wrote in message
...
for anyone to help
I am still uncapable of making a short lookup formula something like this

=lookup(date1:date2, holidays datelist)
i want to count how many holidays are included between 2 given dates.

thanks for kind help
driller


See http://www.j-walk.com/ss/excel/usertips/tip016.htm