Name | last visit | more booked |
John | 01/01/2019 | 1 |
John | 16/01/2019 | |
John | 01/07/2018 | 1 |
Chris | 01/07/2018 | |
Chris | 01/08/2018 | 1 |
Chris | 01/01/2019 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
looking for formula to count if active person within 30 days or if more that 30 days but have booked appointment also count that person
i used that but is wrong
=COUNTIFS($B$2:$B$7,">"&TODAY()-30,$C$2:$C$7,">0")