Can you elaborate on why the formula (which does not necessarily need the date ranges to function) should return a 1 instead of a 3? That is throwing me off.