Excel Magic Trick 1101

Calculate MEDIAN Based On Lower/Upper Date, Exclude Holidays & Weekends

TOPICS IN THIS VIDEO

  • See two formulas:
    1. MEDIAN Lower/Upper Date, Exclude Holidays: MEDAIN with IF, ISNA and MATCH
    2. MEDIAN Lower/Upper Date, Exclude Holidays: AGGREGATE, ISNA and MATCH and Array Calculations
    3. MEDIAN Lower/Upper Date, Exclude Holidays and Weekends: AGGREGATE, ISNA and MATCH and WEEKDAY and Array Calculations

    Median calculation based on criteria: MEDIAN IF or AGGREGATE?