Excel Forum

Excel Magic Trick #189: Count Days Not Sunday

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.

Got a Question? Ask it Here in the Forum.