Dueling Excel

Dueling Excel 033

July 22, 2015 0

First Monday For Reporting Period DESCRIPTION See Mr Excel and excelisfun show three formulas for finding first Monday of reporting period: If 1st day of month is Monday, then that day, otherwise the last Monday […]

Excel Is Fun

Excel Magic Trick 1101

February 27, 2015 0

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 […]