Thread: how to compare a date range another range
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tkraju via OfficeKB.com tkraju via OfficeKB.com is offline
external usenet poster
  
Posts: 109
Default how to compare a date range another range
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

Reply With QuoteReply With Quote