how to compare a date range another range

[tkraju via OfficeKB.com]

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.

 

[Jacob Skaria]

A:A contains the holidays

B1 is the query date

=COUNTIF(A:A,B1)

 

[tkraju via OfficeKB.com]

it didn't yeild the desired results.

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.

 

[Jacob Skaria]

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

it didn't yeild the desired results.

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.