Excel Forum
Similar Content
Get the Number of Workdays Between Two Dates in Excel
Tutorial: How to calculate the total number of working days between two dates in Excel.  This allows...
Years, Months, Days Between two dates in Excel
Tutorial: I have found a rather convoluted method to Calculate the Number of Years, Months and Days ...
Simple Excel Function to Extract a Word or Text from a Cell
Tutorial: Excel function that makes it easy to extract a word or text from a cell in Excel. This is ...



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.