My data are as follows:
site year date
A 2019 2019-08-08
A 2019 2019-08-18
A 2019 2019-10-14
A 2019 2019-10-27
B 2019 2019-08-07
B 2019 2019-08-19
B 2019 2019-10-15
B 2019 2019-10-20
A 2020 2020-08-08
A 2020 2020-08-18
A 2020 2020-10-14
A 2020 2020-10-27
B 2020 2020-08-07
B 2020 2020-08-19
B 2020 2020-10-15
B 2020 2020-10-20
For each year, I would like to subset rows that fulfill the following conditions:
=<October 15 and >=August 15
Thank you in advance!