| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need a function (UDF) return X if 2 dates fall between 2 other dates
what I need is to resolve the following:
Start Date End Date 11/1/09 11/8/09 11/15/09 11/22/09 11/29/09 12/6/09 11/3/09 12/30/09 X X X X X 11/9/09 12/07/09 X X X X X 11/10/09 12/25/09 X X X This is kind of a poor mans gant chart Any help would be appreciated.... |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
need a function (UDF) return X if 2 dates fall between 2 other dates
Try:
=IF(AND($C1=A$2,$C1<=B$2),"X","") Regards, Fred "Chris Salcedo" wrote in message ... what I need is to resolve the following: Start Date End Date 11/1/09 11/8/09 11/15/09 11/22/09 11/29/09 12/6/09 11/3/09 12/30/09 X X X X X 11/9/09 12/07/09 X X X X X 11/10/09 12/25/09 X X X This is kind of a poor mans gant chart Any help would be appreciated.... |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
need a function (UDF) return X if 2 dates fall between 2 other dat
Hi Chris,
put the following formula in cell C2: =IF(OR(AND($A2=C$1,$A2<D$1),AND($B2=C$1,$B2<D$1) ,AND($A2<C$1,$B2C$1)),"X","") Copy the formula for the rest of the cells. A B C D E 1 Start Date End Date 11/1/2009 11/8/2009 11/15/2009 2 11/3/09 12/30/09 X X X 3 11/9/09 12/7/09 X X 4 11/10/09 12/25/09 X X -- If this post helps click Yes --------------- Peggy Shepard "Chris Salcedo" wrote: what I need is to resolve the following: Start Date End Date 11/1/09 11/8/09 11/15/09 11/22/09 11/29/09 12/6/09 11/3/09 12/30/09 X X X X X 11/9/09 12/07/09 X X X X X 11/10/09 12/25/09 X X X This is kind of a poor mans gant chart Any help would be appreciated.... |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
need a function (UDF) return X if 2 dates fall between 2 otherdat
On Sep 1, 7:11*pm, pshepard (donotspam)
wrote: Hi Chris, put the following formula in cell C2: =IF(OR(AND($A2=C$1,$A2<D$1),AND($B2=C$1,$B2<D$1) ,AND($A2<C$1,$B2C$1)),"X","") Copy the formula for the rest of the cells. * * * * A * * * B * * * * * * * C * * * D * * * E 1 * * * Start Date * * *End Date * * * * * * * *11/1/2009 * * * 11/8/2009 * * * 11/15/2009 2 * * * 11/3/09 12/30/09 * * * * * * * *X * * * X * * * X 3 * * * 11/9/09 12/7/09 * * * * * * * * X * * * X 4 * * * 11/10/09 * * * *12/25/09 * * * * * * * * * * * *X * * * X -- If this post helps click Yes --------------- Peggy Shepard "Chris *Salcedo" wrote: what I need is to resolve the following: Start Date * End Date * * * * * 11/1/09 * * 11/8/09 * * *11/15/09 11/22/09 * *11/29/09 * *12/6/09 11/3/09 * * * 12/30/09 * * * * * * * * X X * * * * * * * X * * * * * * X * * * * * * *X 11/9/09 * * * 12/07/09 X * * * * * * * X * * * * * * X * * * * * * *X * * * * * * X 11/10/09 * * 12/25/09 X * * * * * * * X * * * * * * X This is kind of a poor mans gant chart Any help would be appreciated.... Thanks Fred and Peggy, Fred yours did not quite work correctly but Peggy yours worked perfectly... Thanks both of you for your help ...... Chris |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
need a function (UDF) return X if 2 dates fall between 2 other
Hi Chris,
You are welcome. Would you mind indicating that this was helpful by clicking Yes? Thanks, Peggy Shepard "Chris Salcedo" wrote: On Sep 1, 7:11 pm, pshepard (donotspam) wrote: Hi Chris, put the following formula in cell C2: =IF(OR(AND($A2=C$1,$A2<D$1),AND($B2=C$1,$B2<D$1) ,AND($A2<C$1,$B2C$1)),"X","") Copy the formula for the rest of the cells. A B C D E 1 Start Date End Date 11/1/2009 11/8/2009 11/15/2009 2 11/3/09 12/30/09 X X X 3 11/9/09 12/7/09 X X 4 11/10/09 12/25/09 X X -- If this post helps click Yes --------------- Peggy Shepard "Chris Salcedo" wrote: what I need is to resolve the following: Start Date End Date 11/1/09 11/8/09 11/15/09 11/22/09 11/29/09 12/6/09 11/3/09 12/30/09 X X X X X 11/9/09 12/07/09 X X X X X 11/10/09 12/25/09 X X X This is kind of a poor mans gant chart Any help would be appreciated.... Thanks Fred and Peggy, Fred yours did not quite work correctly but Peggy yours worked perfectly... Thanks both of you for your help ...... Chris |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return a Value between dates based on another Value | Excel Worksheet Functions | |||
| return a sum between two dates | Excel Worksheet Functions | |||
| Return the dates something happens | Excel Worksheet Functions | |||
| Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
| how would I count dates (not # of days) in cells that fall betwee. | Excel Worksheet Functions | |||
Linear Mode
