"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

Or if that was down see
http://www.dailydoseofexcel.com/arch...9/networkdays/