Spreadsheet Formulas

css navigation by Css3Menu.com

Count Number by Month

Array formula where we count the number of cells where a date is in a particular month.

Remember To tell Excel that your formula is an array, hold the Ctrl & Shift keys while pressing Enter. Brackets {} will be displayed around it.


Starting from the middle, take the dates in B3 through B14 and convert to text in the format mmddyy. Grab the left 2 characters (mm) and look for 12. If found add 1, if not add zero.

© 2000-2017

Updated:  06/14/2017 17:53
This page added:  06 April 2000