Thread: need a function (UDF) return X if 2 dates fall between 2 other dates
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chris Salcedo Chris Salcedo is offline
external usenet poster
  
Posts: 25
Default 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....
Reply With QuoteReply With Quote