COUNTIF anumber of entries in a date range 14-30 days before TODAY?

[HeathWilD]

Hi guys, first time poster occasional lurker.
I need help with a formula to count the number of entries in a column of dates that are between 14 and 30 days old from TODAY (automatic system date)
Where I am at is =COUNTIF(U1:U999,) which specifies the range of cells I want to count within however specifying how to count back from today(without manual date entry) has me stumped??
Any help would be great

Cheers

Heath


Example date ranges.xlsx

[vlady]

something like this, i think

=COUNTIFS(A4:A185,">="&TODAY()-30,A4:A185,"<="&TODAY()-14)

[HeathWilD]

Perfect Vlady, thankyou!!

[vlady]

Welcome .

[Mathiusuk]

something like this, i think

=COUNTIFS(A4:A185,">="&TODAY()-30,A4:A185,"<="&TODAY()-14)

Can this be used in an already existing countifs.
Example I have a countifs =COUNTIFS($K$23:$K,$P3,$F$23:$F,$AN$2,$D$23:$D,AP$2,$A$23:$A,"<="&today()-14) but last bit isn't right. I want it to only count if column a has a date between "today" and 14 days ago (as in any date in those two weeks prior to the current "today". Can it be done ?

[protonLeah]

@Mathiusuk,
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.