excel - If two sets of dates fall within another set of dates -
see example below.
i need show true , false values shown in example.
the logic needs make sure "start , end" falls within columns time period. column d's time period therefore 9th 14th dec, next column (e) 15th 20th december , on. think of gantt chart showing timeframes.
here version
=and(d$1<=$b2,e$1-1>=$a2)
see: check if 2 date ranges overlap
note: above formula can shown equivalent 'not' form using de morgan's law
could simplify further
=and(d$1<=$b2,e$1>$a2)
Comments
Post a Comment