| 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to compare a date range another range
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to compare a date range another range
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to compare a date range another range
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 |
| Reply |
| 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 | |||
Linear Mode
