Count Date Values of Current Month - MS Excel -

Count Date Values of Current Month - MS Excel -

i have next date values (with time) in column a.

1/1/2012 8:50 1/1/2012 8:45 1/1/2012 8:55 1/1/2012 8:59 1/1/2012 8:12 3/1/2012 8:30 1/1/2012 9:50 2/1/2012 10:00

now, want count of cells column having date values of current month.

i have thought of next formula, suspect work in machines having mm-dd-yyyy system-date-format.

=countifs(a:a,">="&datevalue(month(today())&"-1"&"-"&year(today())),a:a,"<"&datevalue(month(today())+1&"-1"&"-"&year(today())))

any workaround/trick this?

you can utilize countifs current month this

=countifs(a:a,">="&eomonth(today(),-1)+1,a:a,"<"&eomonth(today(),0)+1)

excel excel-formula formula formulas