Using the Count functin to calculate dates between a specific time period

I am struggling with creating a formula that references a date column on another sheet to provide the total of dates that are between a specific time period. ie. during the last week.

This is what I have come up with thus far:

=COUNTA('Data Entry'!P2:P58999,">=TODAY()-7,<=Today()")

Not sure if a countif or a countifs statement should be used.

I want to total entries for dates that have been entered during the time period of 'last week'

Also, will be needing a formula to calculate entries the same entries that have dates during the last month.

Thanks.

Try

=COUNTIFS('Data entry'!P:P,">=" &TODAY()-7,'Data entry'!P:P,"<=" &TODAY())

This is last 8 days so change ">=" or "<=" as required

For previous month

=COUNTIFS('Data entry'!P:P,">=" & A1,'Data entry'!P:P,"<=" &EOMONTH(A1,0))

where A1=Start of month date e.g. 01/02/2017 (1st Feb)

Thanks. I really appreciate the response. I got the weekly formula working as needed, however, I did not try the monthly formula. Made the executive decision since we are not going to track the data by months at this time. It may come in handy in the future. I had been battling with this formula off and on for two days.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.