Calculate number of rows with current month & year in Google Sheets or Excel -


i have 1 row filled dates in format mm/dd/yyyy (with header row), such as:

dates 5/12/2015 4/12/2012 5/7/2015 5/7/2014 

i count number of rows match current month & year. in example above, result 2 (when it's may 2015).

is possible achieve result using function? preferably using google spreadsheet, excel fine.

in google sheets can use

=count(filter(a:a,month(a:a) = month(today()),year(a:a)=year(today()))) 

where a:a column dates


Comments

Popular posts from this blog

android - MPAndroidChart - How to add Annotations or images to the chart -

javascript - Add class to another page attribute using URL id - Jquery -

firefox - Where is 'webgl.osmesalib' parameter? -