All articles with 'writing formulas' Tag
{ 62 Comments }
Check if two ranges of dates overlap [Excel Formulas]
Published on Jun 1, 2010 in Learn Excel
While preparing a project plan, I had a strange problem. I wanted to highlight all the project tasks that fall with-in a certain date range. At the lowest level, the problem is like this: There are 2 ranges of dates (a,b) and (x,y) and I want to know if they overlap (ie at least one […]
Continue »