"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