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




Be the first to comment

Leave a Reply