Excel Forum
Similar Content
Delete All Chart Sheets in Excel - Only Chart Sheets are Deleted - Not Embedded Charts
Macro: Delete all chart sheets and tabs in Excel using this macro. This will only delete the char...
Count the Errors in a Range in Excel
Tutorial: How to count the number of errors in a range in Excel; also, how to count the occurrence ...
Loop through All Worksheets in Excel using VBA and Macros
Tutorial: Ill show you how to loop through all of the worksheets in a workbook in Excel using VBA an...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



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.