If B$2 is greater than or equals to today() and if $a2 is greater than 0 insert "Yes" other wise "No"
I've a Google Sheet where you can spread your magic dust. Have you look here https://docs.google.com/spreadsheets/d/1ofGGVs0UBpWHMKhzlGdwIaOEm3VFd9qumZ9AWUmzLcw/edit#gid=0