|
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 |
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 |
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 |
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 |
| All times are GMT +1. The time now is 06:28 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com