Dueling Excel 044


Count Mondays Between 2 Dates WEEKDAY or TEXT?

DESCRIPTION

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.

WORKBOOKS