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.