[TABLE="width: 297"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Name[/TD]
[TD]last visit[/TD]
[TD]more booked[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD="align: right"]01/01/2019[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD="align: right"]16/01/2019[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD="align: right"]01/07/2018[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Chris[/TD]
[TD="align: right"]01/07/2018[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Chris[/TD]
[TD="align: right"]01/08/2018[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Chris[/TD]
[TD="align: right"]01/01/2019[/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
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")
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Name[/TD]
[TD]last visit[/TD]
[TD]more booked[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD="align: right"]01/01/2019[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD="align: right"]16/01/2019[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD="align: right"]01/07/2018[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Chris[/TD]
[TD="align: right"]01/07/2018[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Chris[/TD]
[TD="align: right"]01/08/2018[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Chris[/TD]
[TD="align: right"]01/01/2019[/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
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")