Thread: need a function (UDF) return X if 2 dates fall between 2 other dates
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
  
Posts: 2,389
Default 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....

Reply With QuoteReply With Quote