A:A contains the holidays

B1 is the query date

=COUNTIF(A:A,B1)

--
If this post helps click Yes
---------------
Jacob Skaria


"tkraju via OfficeKB.com" wrote:

I have w/sheet holiday dates of current year.How to compare these dates with
current month,whether any date in holiday range exists in current month.What
formula gives me right results?
Col A -----------ColB-------------------ColC
date-------------Description----------- day
01/26/2009--Republic day ---------monday
04/20/2009 --Founders day---------monday
05/01/2009----Labour day------------friday
08/15/2009 --IndependenceDay--saturday
I also want to compare that day with with employees' weekly off day.If weekly
off day is matching with holiday week day ,employee is not elible for
holiday.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200904/1