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
Post a Comment