Sep 05 2020 04:11 PM
I'm trying to count a number of years a member has belonged to the group, but only if they have paid their dues, how do I do that? I list in a column the date they paid their dues, and I would like the continuous years column then to figure the number of years they have belonged if their is a date in that column.
Sep 05 2020 10:22 PM
Perhaps a formula like in the attached file? It will show zero if the dues cell is blank.
Or, if you want it to display something else, you could use an IF function:
=IF(B2>0, DATEDIF(A2,TODAY(),"y"), "NOT PAID")