Excel Magic Trick 1101

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

DESCRIPTION

See two formulas:
(04:00) MEDIAN Lower/Upper Date, Exclude Holidays: MEDAIN with IF, ISNA and MATCH
(08:29) MEDIAN Lower/Upper Date, Exclude Holidays: AGGREGATE, ISNA and MATCH and Array Calculations
(12:40) MEDIAN Lower/Upper Date, Exclude Holidays and Weekends: AGGREGATE, ISNA and MATCH and WEEKDAY and Array Calculations

WORKBOOKS

Download “Excel Magic Trick 1101-1120” Excel-Magic-Trick-1101-1120.zip – Downloaded 14 times – 2 MB




Be the first to comment

Leave a Reply