Countif for between today and the end of the month

[Timmithon]

Hi there,

I'm trying to count all the cell that fall between the current day's date and the end of the month.

I've been trying this formula and similar iterations to no luck:

=COUNTIFS('Milestones'!J:J,">=Today()", 'Milestones'!J:J,"<=EOMONTH(TODAY(),0)")

Is it not possible to use the Today() or EOMONTH functions in this kind of formula or something?
If not a work-around would be greatly appreciated, thanks!

 

[SteveO59L]

something along the lines of

=COUNTIF(O9:O29,"<="&EOMONTH(TODAY(),0))-COUNTIF(O9:O29,"<="&(TODAY()))

or

=COUNTIFS(O9:O29,"<="&EOMONTH(TODAY(),0),O9:O29,">="&TODAY())

 

[Aladin Akyurek]

Unquote formula expressions...

=COUNTIFS('Milestones'!J:J,">="&Today(), 'Milestones'!J:J,"<="&EOMONTH(TODAY(),0))

 

[bhos123]

=COUNTIFS(Sheet1!J:J,">="&Today(), Sheet1!J:J,"<="&MONTH(TODAY()))