Use the IF condition along with countif. If Countif is 0 then the query
date is a holiday..

A:A contains the holidays

B1 is the query date

=IF(COUNTIF(A:A,B1)0,"Holiday","")


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


"tkraju via OfficeKB.com" wrote:

it didn't yeild the desired results.
Jacob Skaria wrote:
A:A contains the holidays

B1 is the query date

=COUNTIF(A:A,B1)

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
[quoted text clipped - 8 lines]
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