Excel Forum

Mr Excel & excelisfun Trick 44: Count Mondays Between 2 Dates WEEKDAY or TEXT?

See Mr Excel and excelisfun count the number of Mondays between two dates using the WEEKDAY function or the TEXT function wrapped around the ROW and INDIRECT function. Mr Excel uses SUM and Ctrl + Shift + Enter and excelisfun uses SUMPRODUCT and Enter.

Got a Question? Ask it Here in the Forum.