From a start date and an end date, see how to count all the days except for Sunday using an array formula that uses the functions SUM, IF, ROW, INDIRECT, SUMPRODUCT and TEXT. See a list of 10 different formulas from the mr excel Message Board that will blow your mind.
Questions about Excel Magic Trick #189: Count Days Not Sunday
Want more info about Excel Magic Trick #189: Count Days Not Sunday?
Get free advice from education experts and Noodle community members.