| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare an Array to a Date Range | Excel Discussion (Misc queries) | |||
| Rolling up the latest date, criteria of range to compare highest d | Excel Programming | |||
| COUNTIF to compare one range versus another range | Excel Programming | |||
| Compare a selected Range with a Named range and select cells that do not exist | Excel Programming | |||
| Compare date of a transaction against a range of dates | Excel Worksheet Functions | |||
Threaded Mode
